Lookup value based on 2 cell values
Try this:
=VLOOKUP(B1,D1:M9,MATCH(A1,{"LCT","LCB"},)+1,)
"BorderMaster" wrote:
Hello all,
I am trying to find a way to search through a table the value based on
2 other cells. The 2 base cells have 9 and 10 different possibilities
respectively so this gives me a table with 90 options. How can I do
this? My first thought was something like this:
=IF(A1="LCT";VLOOKUP(B1;D1:M9;2);IF(A1="LCB";VLOOK UP(B1;D1:M9;3);...)
The problem is that I have more than 7 "IF" and I cannot do this in
Excel 2K3.
Can someone help me? I would like to be able to grow the table as
needed.
Thanks in advance.
|