hello,
plz if i put number in a1 cell i want to get name of product in the same cell
how it can be?
thx
hello,
plz if i put number in a1 cell i want to get name of product in the same cell
how it can be?
thx
That's not enough information. Give several examples
Ben Van Johnson
example:
if i write 1 in a1 cell
it will be apple
Where will the lookup table be in your workbook? You will need one that lists your number codes next to your products. Then you can use VLOOKUP:
=VLOOKUP(A1,lookup_array,2,0)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
No. Use data validation, dropdown list or autocorrect using abbreviations for the prod name.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks