Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Vlookup using a range condition
I have three worksheets: Main, PM1, PM2
I have a named range "PM_Ranges=PM1:PM2!$A$2:$G$20 " Each worksheet has the same amount of columns. Column A in worksheets PM1 and PM2 has a unique reference "Project" for each of the worksheets. Worksheet Main column A has all the "Projects". I am attempting to use Main as a combination of all worksheets by attempting to search the PM_Range and get all the corresponding column information for a given project. I have attempted the following: = vlookup(Main!A1,PM_Range,2,false) and I only get #Value. but if I use = vlookup(Main!A1, PM1!$A$2:$G$20,2,false) it works but only for the PM1 worksheet I need it to search all worksheets. Any thoughts? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create range bar graph | Charts and Charting in Excel | |||
How to Select a relative range with Using "Find" and Offset() | Excel Discussion (Misc queries) | |||
Reveal cell formats and extendable range in tool/statusbar/icon. | Excel Worksheet Functions | |||
Vlookup - Range | Excel Discussion (Misc queries) | |||
Dynamic Print Range Help | Excel Worksheet Functions |