Hi Chaps, I have two spread sheets which I need to which I need to cross check information. The formula works except I get a zero where I want a blank cell and a black cell if the entry doesn't exist on both sheets, this is making me loose my mind.
the only time this works is if the property is on one sheet and not the other.
I have the same properties in both books, and I need to transfer dates in one column in one sheet to the other, I would do it manually but there are nearly 500 entries....
Any help would be much appreciated!
Code:
=IFERROR(VLOOKUP(A5,'FRA MASTER LIST - FRAs due Aug_Sep.xlsx'!Table1[[#Headers],[#Data]],26,FALSE),"")
the only time this works is if the property is on one sheet and not the other.
I have the same properties in both books, and I need to transfer dates in one column in one sheet to the other, I would do it manually but there are nearly 500 entries....
Any help would be much appreciated!