Hello.

I am trying to use an IF statement, and I am not sure how to proceed further. What I need the formula to do is this: If cell B2 is blank, then return blank, if not the retrieve the name associated with the content of cell b2. I have written this part. I need to add: if B2 is STILL blank after the first search, then look for the associated name in another place. I have attached a small sample of my workbook.

IF THIS DO THIS IF STILL THIS DO THIS.xlsm

Any help will be greatly appreciated!

Emma