Is vlookup appropriate?

[asker2]

MY PROBLEM IS THIS:
I have an EXCEL 2010 spreadsheet with an empty column (titled "AA") with 200 rows, in which each cell can have inserted - only the values "A" thru "Z" (26 single-letter possibilities).

Any letter entry can be repeated as many times as desired in column AA cells. In other words column AA could have 200 entries of letter "A"

In a separate chart, each letter can have a corresponding whole number value from 1 to 200. Duplicate number values from letter to letter are allowed. Note that some letters may have no corresponding value entered.

I would like to create a formula in each cell of a second empty column (titled "BB") such that whenever a letter is entered in any row in column AA, the letter's corresponding numerical value will appear in same row in column BB.

Cells in Column BB should always be empty if there is no value in corresponding cell in Column AA

I hope this is clear

thanks for any assistance in creating the spreadsheet

Alan D

 

[Scott T]

If what you want is something like this then VLOOKUP will work fine

Book1
	A	B	C	D	E	F	G	H
1	AA						A	1
2	A	1					B	2
3	t	66					C	8
4	A	1					D	54
5	s	7					E	3
6	t	66					F	678
7	A	1					G	2
8	s	7					H	2
9	f	678					I	68
10	A	1					J	320
11	A	1					K	2
12	q	4					L	42
13	z	3					M	42
14	A	1					N	4
15	y	48					O	2
16	j	320					P	4
17	A	1					Q	4
18	A	1					R	44
19							S	7
20							T	66
21							U	13
22							V	48
23							W	2
24							X	3
25							Y	48
26							Z	3
Sheet1

Cell Formulas
Range	Formula
B2	=IF(A2="","",VLOOKUP(A2,$G$1:$H$26,2,0))
B3	=IF(A3="","",VLOOKUP(A3,$G$1:$H$26,2,0))
B4	=IF(A4="","",VLOOKUP(A4,$G$1:$H$26,2,0))
B5	=IF(A5="","",VLOOKUP(A5,$G$1:$H$26,2,0))
B6	=IF(A6="","",VLOOKUP(A6,$G$1:$H$26,2,0))
B7	=IF(A7="","",VLOOKUP(A7,$G$1:$H$26,2,0))
B8	=IF(A8="","",VLOOKUP(A8,$G$1:$H$26,2,0))
B9	=IF(A9="","",VLOOKUP(A9,$G$1:$H$26,2,0))
B10	=IF(A10="","",VLOOKUP(A10,$G$1:$H$26,2,0))
B11	=IF(A11="","",VLOOKUP(A11,$G$1:$H$26,2,0))
B12	=IF(A12="","",VLOOKUP(A12,$G$1:$H$26,2,0))
B13	=IF(A13="","",VLOOKUP(A13,$G$1:$H$26,2,0))
B14	=IF(A14="","",VLOOKUP(A14,$G$1:$H$26,2,0))
B15	=IF(A15="","",VLOOKUP(A15,$G$1:$H$26,2,0))
B16	=IF(A16="","",VLOOKUP(A16,$G$1:$H$26,2,0))
B17	=IF(A17="","",VLOOKUP(A17,$G$1:$H$26,2,0))
B18	=IF(A18="","",VLOOKUP(A18,$G$1:$H$26,2,0))
B19	=IF(A19="","",VLOOKUP(A19,$G$1:$H$26,2,0))
B20	=IF(A20="","",VLOOKUP(A20,$G$1:$H$26,2,0))
B21	=IF(A21="","",VLOOKUP(A21,$G$1:$H$26,2,0))
B22	=IF(A22="","",VLOOKUP(A22,$G$1:$H$26,2,0))
B23	=IF(A23="","",VLOOKUP(A23,$G$1:$H$26,2,0))
B24	=IF(A24="","",VLOOKUP(A24,$G$1:$H$26,2,0))
B25	=IF(A25="","",VLOOKUP(A25,$G$1:$H$26,2,0))
B26	=IF(A26="","",VLOOKUP(A26,$G$1:$H$26,2,0))

 

[asker2]

So elegant, so clean.
Works as you indicated it would.

I thank you for taking the time to solve my problem.



AlanD