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?