Hi All
I am looking up columns from one workbook to another.
So in Book1 Column A I need data from Book2 Column A then Column B than C etc...
I have looked up Column A & Column B from Book2 as above and it worked fine however, Column C & D are returning zero where there is information on the cells.
There cant be anything wrong with data in Book1 column as I did get proper results on first two look ups.
Anyone?
Bookmarks