How to fill adjacent column using a table lookup...

N

Naran Hirani

Hi,

I have a couple of columns in an excel worksheet, e.g.
Plate Well
1 A01
1 A02
1 A03
1 A04
1 A05
1 A06
1 A07
1 A08
1 A09
1 A10
1 A11
1 A12
1 B01
1 B02
1 B03
1 B04
1 B05
1 B06
1 B07
1 B08
1 B09
1 B10
1 B11
....


And I would like to fill an adjacent column in the same sheet based by
looking up the value in a lookup table and returning it's col and row
positions in the table.

The table looks something like:
F1 A B C D ... P
1 1a01 2a01 1b1 2b1 .
2 3a01 4a01 3b1 4b1 .
3 1a02 2a02 1b2 2b2
4 3a02 4a02 3b2 4b2
5 1a03 2a03 1b3 2b3
6 3a03 4a03 3b3 4b3
7 1a04 2a04 1b4 2b4
8 3a04 4a04 3b4 4b4 ....
9 1a05 2a05 1b5 2b5
10 3a05 4a05 3b5 4b5
11 1a06 2a06 1b6 2b6
12 3a06 4a06 3b6 4b6
13 1a07 2a07 1b7 2b7
14 3a07 4a07 3b7 4b7
15 1a08 2a08 1b8 2b8
16 3a08 4a08 3b8 4b8
17 1a09 2a09 1b9 2b9
18 3a09 4a09 3b9 4b9
19 1a10 2a10 1b10 2b10
20 3a10 4a10 3b10 4b10
21 1a11 2a11 1b11 2b11
22 3a11 4a11 3b11 4b11
23 1a12 2a12 1b12 2b12
24 3a12 4a12 3b12 4b12

so using the first row of the input worksheet it would look up 1A01 in
the above table and return: 1A1, etc.

Can some please show me how to do this?

I am sure it is possible just a bit of novice at this new fangled Excel
stuff though ;-)

Many thanks.
Naran.
 
Top