Hi everyone

I am not an expert on Excel but have generally managed to get round
most things but this problem has me stumped.

I have 3 rows of numbers; each row preceeded by a letter.

A 1 2 3 4 5 6 7 8 9 10
B 11 12 13 14 15 16 17 18 19 20
C 21 22 23 24 25 26 27 28 29 30

Basically if a cell contains one of these numbers, I want the formula
in an adjacent cell to fill in the letter from that row e.g. 6=A; 19=B;
23=C.

I can make it work using nested IF statements but I felt that VLOOKUP
might be a better solution but cannot make this work in any way shape
of form; even comparing it with other examples.

I can make it work with the 1st column of numbers i.e. 1, 11 or 21 but
the minute I change the range to include the 1st Column (ABC) it comes
up with #N/A error.

Would appreciate any help on resolving this problem ...thanks


--
Spellbound
------------------------------------------------------------------------
Spellbound's Profile: http://www.excelforum.com/member.php...o&userid=32697
View this thread: http://www.excelforum.com/showthread...hreadid=525206