Hi,

The +1 is added because the MATCH returns 1 or 2 depending on which one you
were looking for, but in the VLOOKUP range the column from which you want to
return the result is either 2 or 3 because the first column is the lookup
column so +1.

You can also use
=SUMPRODUCT((E1:M1=A1)*(D211=B1)*E2:M11)

where the data range looks something like:
E F G ....
1 LCT LCB
2 B 77 19
3 A 35 6
4 C 29 23
5 D 61 5
6 E 10 56
7 F 68 89
8 G 28 70
9 Z 62 35
10 N 45 44

And you enter the items you want to search for in A1 and B1.

By using range references you make the formula a lot more flexible.

Where the

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"BorderMaster" wrote:

On Feb 7, 8:44 am, Teethless mama
wrote:
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.

It is working. Thank you so much! What does the "+1" stand for in the
formula?