Please see attached sample workbook.
Form1 is where users forms requests are being recorded.Sheet 2 is where I want the formula to be applied (in Column H). I have put the desired result in the column.
I want to lookup the ID number in Column A of Sheet 2 against Form1 and return the client name from one of the 12 cells that could contain a client name (only one of these 12 cells will ever have a value in).
As I mentioned before, the formula was working fine before I tried to add the four new column/cell references (AH, AI, AJ and AK).
Hopefully this makes sense - happy to clarify further if needed!
|