Simple Table array lookup

Stuartsteed

New Member
Joined
Sep 11, 2007
Messages
9
Hi, and good day to you all !!, my first posting here so please stay with me if my question gets a tad confusing!.
I am frying my brain trying to work out a formula for the following problem.

I have data in a simple table like as follows:-

code 01 02 03 04
989898 159 142 130 789
979797 1147 1075 2685 3213
969696 899 6666 787 4555
959595 744 812 541 258
949494 111 5589 598 104

On a seperate sheet i have two columns of data

949494 01
949494 02
949494 03
959595 01
959595 02
959595 03


What i want to do is to find the value from the first sheet that relates to the code in sheet 2 column A (e.g. 949494), but the value in the column
so for example in the cell next to 949494 03 the figure should be 598, for 959595 02 the figure should be 812, and so on.

I know this is simple, but hey its Friday!!

Many thanks for any assistance
 

Some videos you may like

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

Dan Waterloo

Well-known Member
Joined
Jan 4, 2007
Messages
874
Try, in cell C1 of sheet 1
Code:
=VLOOKUP(A1, sheet2!$A$2:$E$6, B1, false)

and copy this down column C.
 

Watch MrExcel Video

Forum statistics

Threads
1,126,939
Messages
5,621,722
Members
415,853
Latest member
Newlife72

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
Top