| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need Simple List...Multiple Columns and Multiple Worksheets | Excel Worksheet Functions | |||
| Vlookup for multiple criteria, multiple worksheets | Excel Worksheet Functions | |||
| linking multiple columns onto multiple worksheets | Excel Discussion (Misc queries) | |||
| vlookup multiple worksheets | Excel Worksheet Functions | |||
| Vlookup against multiple columns/worksheets question | Excel Discussion (Misc queries) | |||
Linear Mode
