Are the ranges for your lookup tables in the same location for each
sheet?

What are the ranges for your tables?

How are your sheet tabs named?

In article ,
"jiwolf" wrote:

I have a list of 120 items that I have to search for amongst 5 list of data
on 5 different worksheets. Is there a way of searching for them all in one
go across the 5 worksheets? using individual lookups would take an age!


and ideas anyone?