Simple Table array lookup

[Stuartsteed]

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

 

[Dan Waterloo]

Try, in cell C1 of sheet 1

=VLOOKUP(A1, sheet2!$A$2:$E$6, B1, false)

and copy this down column C.