Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to use 2 worksheets in one formula with INDIRECT & VLOOKUP
I am trying to pull in information from two different worksheets into one
column, but some of the inofrmation from one sheet is different from the other, and some of the information is the same, and if it chages I want it to change automatically so right now I have this formula which does NOT work ---- =VLOOKUP(A5, INDIRECT("'"& $C$1 &" information'!$A$4:$L$97"; "'"& D1 &" information'!$A$4:$L$97"),12,FALSE)) ----- the C$1$ and D$1$ are references for 2005 and 2004 which would pull from those sheets, so if i change it to 2006 it will pull from the 2006 sheet automatically. Am i way off on the formula? Or is this even possible? If it is HOW? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to use 2 worksheets in one formula with INDIRECT & VLOOKUP
Hi!
Am i way off on the formula? Yes and no. You can't use multiple lookup tables like that. While it would be technically possible to return multiple values from 2 different lookups to a single cell, it is (would be) a real pain to maintain. Why don't you just use separate cells? It would be MUCH easier! Otherwise, use this as a guide: =VLOOKUP(A5,INDIRECT("'"&C1&"'!A1:B5"),2,0)&","&VL OOKUP(A5,INDIRECT("'"&D1&"'!A1:B5"),2,0) Biff "NEWB" wrote in message ... I am trying to pull in information from two different worksheets into one column, but some of the inofrmation from one sheet is different from the other, and some of the information is the same, and if it chages I want it to change automatically so right now I have this formula which does NOT work ---- =VLOOKUP(A5, INDIRECT("'"& $C$1 &" information'!$A$4:$L$97"; "'"& D1 &" information'!$A$4:$L$97"),12,FALSE)) ----- the C$1$ and D$1$ are references for 2005 and 2004 which would pull from those sheets, so if i change it to 2006 it will pull from the 2006 sheet automatically. Am i way off on the formula? Or is this even possible? If it is HOW? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Vlookup formula Excel version 2002 | Excel Discussion (Misc queries) | |||
IF / VLOOKUP formula won't work until saved | Excel Worksheet Functions | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
How do I use Range Names listed in a VLookup table in a formula? | Excel Worksheet Functions |