Forum Discussion
Solved
How to return text after entering an associated number?
UPDATE: I'VE ADDED AN EXAMPLE SPREADSHEET I have a database of location names an their corresponding location codes. Over time, people using the database have used slightly different spellings of...
AKnott1620 All these below formula should work if I understand your question correctly.
=VLOOKUP(B2,Table7,2,0) =XLOOKUP(B2,Table7[Site Code],Table7[Site Name]) =INDEX(Table7[Site Name],MATCH(B2,Table7[Site Code],0))Recommended formula is to use XLOOKUP().
I have a list of unique location codes along with their correctly spelled location names, correct. I want to use this "master" list to fill in a column with the correctly spelled location names. Next to the blank column is a list of the location codes. I can upload an example.
AKnott1620 All these below formula should work if I understand your question correctly.
=VLOOKUP(B2,Table7,2,0)
=XLOOKUP(B2,Table7[Site Code],Table7[Site Name])
=INDEX(Table7[Site Name],MATCH(B2,Table7[Site Code],0))Recommended formula is to use XLOOKUP().
Harun24HR Yes, this is exactly what I was looking for! Thank you so much!!