Attn: Excel Gurus

[Jellyfishpudding]

I have a list of items that I reference by number. Example below. I would like to type the number of an item into a cell and have the item name appear in its place. I type "3" and "Poplar" appears. This seems like it would be very simple, but I haven't found the formula. Any help would be greatly appreciated! -Eddie

1-Pine
2-Oak
3-Poplar
4-Birch

 

[termite]

You could probably use =VLOOKUP function and have it reference a separate tab with the list.

I am not near a computer though to build a mock up.

 

[termite]

I have a list of items that I reference by number. Example below. I would like to type the number of an item into a cell and have the item name appear in its place. I type "3" and "Poplar" appears. This seems like it would be very simple, but I haven't found the formula. Any help would be greatly appreciated! -Eddie

1-Pine
2-Oak
3-Poplar
4-Birch

=VLOOKUP will do exactly what you want.

=VLOOKUP(Cell you enter data, cell:table_aray, row reference data is in, range_lookup [use false to get exact match])

the below screenshot has this formula.

=VLOOKUP(C7,A1:B4,2,FALSE)