Is there more than one answer possible, such as one on each sheet?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"thecdnmole" wrote in message
...
I have two worksheets, same format, different data. Let's say for
simplicity
worksheet one has numbers from 1 to 100 and worksheet 2 from 101 to 200.
On
a third worksheet I want to have a search feature, so that if I am looking
for number 20 it looks for it on both sheets, another example would be
150,
it needs to seach both worksheets and provide an answer in the cell.
Thansk!