Jane Collins
New Member
- Joined
- Jul 22, 2005
- Messages
- 17
=VLOOKUP($B$1,Open_Percent,D$83,FALSE)
I need to change the above formula to also include the look up of cell $B91.
Something like this:
=VLOOKUP($B91,$B$1,Open_Percent,D$83,FALSE) but it doen't work.
I want to check that both B91 & B1 match the criteria in Open_Percent (range) and return value that matches D83 column number.
Is there a solution?
I need to change the above formula to also include the look up of cell $B91.
Something like this:
=VLOOKUP($B91,$B$1,Open_Percent,D$83,FALSE) but it doen't work.
I want to check that both B91 & B1 match the criteria in Open_Percent (range) and return value that matches D83 column number.
Is there a solution?