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

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

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,127,237
Messages
5,623,542
Members
415,977
Latest member
Tommyboy30

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