VLOOKUP help

Mightybeav

New Member
Joined
Nov 3, 2005
Messages
2
I need to extract a value from a table that has 10 rows and 5 columns. I have tried using the vlookup but can only make it work if the table is 3 columns. Depending on two variables, I need to extract a value for, ie, cell = row 5, column 4. Any help here is greatly appreciated.

Thanks Jim

buzz me on yahoo if needed. note in request that this is what it is about
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
Welcome to MrExcel - you can use VLOOKUP/MATCH

=VLOOKUP(Z1,A1:E10,MATCH(X1,A1:E1,0),0)

Will find in A1:E10 the cell intersected by Z1 in A1:A10 and X1 in A1:E1

EDIT to change F refs to E refs.
 
Upvote 0
Book1
ABCDEFG
1A1234AA27
2B56783
3C9101112
4X13141516
5Y17181920
6Z21222324
7AA25262728
8BB29303132
9CC33343536
10QQ37383940
Sheet1


Example - not the refs have changed...

In G1: =VLOOKUP(F1,A1:E10,MATCH(F2,A1:E1,0),0)
 
Upvote 0

Forum statistics

Threads
1,213,554
Messages
6,114,280
Members
448,562
Latest member
Flashbond

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top