J
jbugman
I am trying to use vlookup to reference data in another worksheet using
a cell reference in the current worksheet. I have been able to do this
in a two step process using indirect addressing. I would like to do it
in one step.
Example: A cell B1 can have one of three values Dog, Cat, or Fish.
Another cell, C1, can have one of 10 values which are in each of three
other worksheets labeled Dog, Cat, and Fish
The formula would look something like this however it is not correct:
vlookup(C1,B1!A1:c10,2,false)
a cell reference in the current worksheet. I have been able to do this
in a two step process using indirect addressing. I would like to do it
in one step.
Example: A cell B1 can have one of three values Dog, Cat, or Fish.
Another cell, C1, can have one of 10 values which are in each of three
other worksheets labeled Dog, Cat, and Fish
The formula would look something like this however it is not correct:
vlookup(C1,B1!A1:c10,2,false)