# Simple Table array lookup

#### Stuartsteed

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

### 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
Try, in cell C1 of sheet 1
Code:
``=VLOOKUP(A1, sheet2!\$A\$2:\$E\$6, B1, false)``

and copy this down column C.

Replies
6
Views
152
Replies
1
Views
182
Replies
1
Views
296
Replies
3
Views
531
Replies
29
Views
8K

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.

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