| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup In Another Worksheet
I am trying to do a Vlookup of an array in another worksheet. For example,
vlookup(1,Baseline,2) with "Baseline" as an array in another worksheet. It seems that you could only perform a vlookup in the same worksheet. Is it true? If so, is there another function that performs a similar task as vlookup but in another worksheet? -- Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup In Another Worksheet
VLOOKUP can reference other sheets. Post the formula you're using. Perhaps
the syntax of the reference is incorrect. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Daviv" wrote: I am trying to do a Vlookup of an array in another worksheet. For example, vlookup(1,Baseline,2) with "Baseline" as an array in another worksheet. It seems that you could only perform a vlookup in the same worksheet. Is it true? If so, is there another function that performs a similar task as vlookup but in another worksheet? -- Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup worksheet match in macro | Excel Worksheet Functions | |||
| One worksheet to calulate different items simultaneously | Excel Worksheet Functions | |||
| Vlookup worksheet function | Excel Worksheet Functions | |||
| Updating formula with link to another worksheet using vlookup | Links and Linking in Excel | |||
| Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
Linear Mode
