multiple searches?
 

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?

multiple searches?
 

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?