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?