VLOOKUP with multiple columns or worksheets
 

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.

VLOOKUP with multiple columns or worksheets
 

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


HTH,
JP

On Aug 13, 4:56*pm, Mickey wrote:
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.