Hi BorderMaster,

As you can see by the last two responses, the earlier responses are
guesswork because you didn't show us what your data area looks like.

Good points T.V and HTH!
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"T. Valko" wrote:

Do you have column headers in your table that are LCT, LCB ?

Like this:

...........D..........E...........F
1..................LCT......LCB
2.......0..........10..........12
3.......5..........14..........17
4.......7..........11..........20

If so:

=VLOOKUP(B1;D1:F4;MATCH(A1;D1:F1;0))


--
Biff
Microsoft Excel MVP


"BorderMaster" wrote in message
...
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.