match formula

[Guest]

I can't remember the specific formula to use. I am trying to match initials
and turn them into full words that they stand for. For example, on a mailing,
we have state abbreviations, there are over 500 rows of them. I would like to
turn the initials into the full state name. TX to Texas, etc. I have all 50
states initials in column A. Column B has all their corresponding full names.
In another spreadsheet is the initials in column G. Please help me with the
formula so that column H will have the matching full name of the state.

 

[David McRitchie]

Hi Melissa,
=VLOOKUP(D5,zip2table,2,False)
=VLOOKUP(D5,'sheet two'!$A$1:$B$50, 2, False)

To provide for incorrect coding
=IF(ISNA(VLOOKUP(...,...,...,False)),"Item not found",VLOOKUP(...,...,...,False))

http://www.mvps.org/dmcritchie/excel/vlookup.htm

 

[agarwaldvk]

You may use VLOOKUP formula.


=vlookup(g1,sheet1!A1:B50,2,false)

This will lookup the value in cell g1 in column A on sheet1 and return
the value in column 2 of the range (which in this case is column B on
sheet1)



Best regards




Deepak Agarwal