Excel Formula for multiple lookups
 

I want to look at value in b58 (Jan)and the value in b8(Br 22)(and find the
value at the intersection in worksheet PLAN. I have tried the lookup wizard
and it appears it is going to work until the last option and it returns the
error - the cell found by the wizard contains a formula returning an error.
There are no formulas in Plan worksheet.

Excel Formula for multiple lookups
 

Debra Dalgleish shows how to use =index(match()) for this:
http://www.contextures.com/xlFunctions03.html

I think that's what you need/want.

stephens176 wrote:

I want to look at value in b58 (Jan)and the value in b8(Br 22)(and find the
value at the intersection in worksheet PLAN. I have tried the lookup wizard
and it appears it is going to work until the last option and it returns the
error - the cell found by the wizard contains a formula returning an error.
There are no formulas in Plan worksheet.

--

Dave Peterson

Excel Formula for multiple lookups
 

Yes thank you that is exactly what I needed.

"Dave Peterson" wrote:

Debra Dalgleish shows how to use =index(match()) for this:
http://www.contextures.com/xlFunctions03.html

I think that's what you need/want.

stephens176 wrote:

I want to look at value in b58 (Jan)and the value in b8(Br 22)(and find the
value at the intersection in worksheet PLAN. I have tried the lookup wizard
and it appears it is going to work until the last option and it returns the
error - the cell found by the wizard contains a formula returning an error.
There are no formulas in Plan worksheet.

--

Dave Peterson