VLOOKUP with multiple columns or worksheets

[Mickey]

I was trying search for the value in cell D6 to multiple worksheets but was
not able to. I copied all the information from the several sheets and pasted
it onto diferrent columns. The main columns I need to search are the ones
noted below. I have too much information that would not fit in the limeted
rows.

Cell D6 (has value) Need to search between Columns K,N,P,Q,T


Note:
If it's easier I would want to know how to search cell D6 on multiple sheets
June, July, August, September, etc...

Thanks.

 

[JP]

If you search "vlookup multiple worksheets" in groups.google.com there
were multiple hits on different formulas you can use.


HTH,
JP