Excel Lookup Functions

[Paul Adams]

Thanks, I got it to work for one when I typed in the exact locatio
including which row of cell but I could not get it to work when it use
the cell to lookup the workbook only as I struggled to get it to the
know what rows to look at in that workbook. If I included that in th
cell reference, I would have to have lots of cell references to ge
round it, as I'm using lookups on lots of different rows. Any ideas?

Thanks

Pau