VLOOKUP with multiple columns or worksheets

  • Thread starter Thread starter Mickey
  • Start date Start date
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.
 
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

If statements in a Vlookup. 2
using vlookup with combo box 4
VLOOKUP puzzle ?? 7
Search multiple worksheets and return value based on phone number 1
SUMIF with NAME RANGE 1
match?? 1
INDIRECT Formula with an IF Then issue 7
vlookup or dget with multiple condition - help please 4

Back
Top