AutoFill a Cell based on an Adjacent Cell

[swensja33]

Hi,

I am seeking assistance in auto filing a cell with the location name based on a two letter coded in the adjacent cell. The table with with code and associated location name is located on a separate tab within the same workbook.

For instance:

If the code is "TH" it equals Fort Hood, TX

I attached the workbook for illustration.

The column highlighted in yellow is the source with the two letter code.

The column highlighted in green is the what I need auto filled based on the letter code in the adjacent cell.

Thanks!

[AliGW]

Welcome to the forum.

=INDEX(ORGRAA!$B$8:$B$349,MATCH(A2,ORGRAA!$A$8:$A$349,0))

[MarvinP]

Hi swensja and welcome to the forum,

In B2 put this formula and double click the bottom right of that cell. That will fill down to the bottom and give what I think you want.

Please Login or Register  to view this content.

Vlookup Two Letter to Code.xlsx

[swensja33]

Perfect! Thanks!

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.