VLOOKUP with multiple columns or worksheets

M

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.
 
J

JP

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


HTH,
JP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF with NAME RANGE 1
using vlookup with combo box 4
vlookup in a multiple sheet file 1
Vlookup with changing columns 2
VLookUP with multiple reference columns 6
match?? 1
Search multiple worksheets and return value based on phone number 1
Excel problem - sumif with multiple parameters 2

Top