Kelli Webb
Member
Hi, I hope you're are well.
I would love some assistance to combine vlookup as my first criteria then swap the format from surname, first name to first name surname
vlookup A to get C, if blank use column E - the desired outcome is in Column E
This part I think I've figured out i.e. =IFERROR(RIGHT(C4,LEN(C4)-SEARCH(",",C4)-1)&" "&LEFT(C4,SEARCH(",",C4)-1),D4) with some help from google.
If you are able to assist, I would greatly appreciate it.
Any questions please don't hesitate to ask. take care, Kelli
I would love some assistance to combine vlookup as my first criteria then swap the format from surname, first name to first name surname
vlookup A to get C, if blank use column E - the desired outcome is in Column E
This part I think I've figured out i.e. =IFERROR(RIGHT(C4,LEN(C4)-SEARCH(",",C4)-1)&" "&LEFT(C4,SEARCH(",",C4)-1),D4) with some help from google.
If you are able to assist, I would greatly appreciate it.
Any questions please don't hesitate to ask. take care, Kelli