# Lookup functions

#### Killer_Bud

##### New Member
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.

Regards,

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

#### J88L

##### New Member
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

##### New Member
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 !!!

##### MrExcel MVP
Killer_Bud said:
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.

Regards,

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

#### Killer_Bud

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

Replies
7
Views
133
Replies
2
Views
298
Replies
3
Views
123
Replies
1
Views
106
Replies
11
Views
366

1,195,664
Messages
6,011,019
Members
441,579
Latest member
satishrazdhan

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back