Lookup value based on 2 cell values
On Feb 7, 3:58*pm, Shane Devenshire
wrote:
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.
Thanks everyone,
Sorry for the late response, I was away for a while.
I used something like T.V. wrote where the LCT, LCB... are headers. It
works perfectly.
GM
|