Lookup functions

[Killer_Bud]

I have a table that runs from L2:T52. I am trying to do a lookup function
to look for G3 in Column L and to look for H4 in either Column M,N,O,P,Q,R,S,T and then return the intersecting dollar amount.
Is there a way to do this with one formula ?

ie: Lookup finds G3 on Row 28, and H4 in Column Q and then returns
the intersecting dollar value.

Please help.....been trying to figure this out for many months now !!

Regards,

 

[J88L]

I was able to do this, but had to make an assumption. I'm assuming your range of L2:T52 has headers in L1:T1. I'm assuming you're putting the name of the header / column label in H4.

=VLOOKUP(G3,L2:T52,MATCH(H4,L1:T1,0),0)

Explanation. Looks for value in G3 in the range L2:L52, then returns the value in the nth column, where n is the number of the column that the value of H4 is found in the range L1:T1.

 

[Killer_Bud]

Hi.....your assumption was correct.....but why now when I input this am I getting an N/A# error ? From what I can tell this should work fine ?
Help !!!

 

[Aladin Akyurek]

I have a table that runs from L2:T52. I am trying to do a lookup function
to look for G3 in Column L and to look for H4 in either Column M,N,O,P,Q,R,S,T and then return the intersecting dollar amount.
Is there a way to do this with one formula ?

ie: Lookup finds G3 on Row 28, and H4 in Column Q and then returns
the intersecting dollar value.

Please help.....been trying to figure this out for many months now !!

Regards,

Are L2:L52 and M1:T1 in ascending order?

 

[Killer_Bud]

Thanks......that was the problem ( ascending order )
Works like a charm. Thanks for all the help !!!!