Forum Discussion
Ryan Lange
Nov 24, 2017Copper Contributor
Excel formula help
I am trying to figure out a formula that would allow me to create a result like this... In Column P, I would like it to automatically generate a text based on numbers entered in column N. For ex...
Willy Lau
Nov 24, 2017Steel Contributor
I am not sure how you are familar with EXCEL.
I suggest you create the following in a sub sheet
columnA
1
2
3
columnB
Diamond
Mounting
Gemstone
in your data sheet, columnP use vlookup function to find the value according to columnN. When you are using VLOOKUP, be aware of the difference between Ralative Row/Column and Absolute Reference
VLOOKUP function
https://support.office.com/en-gb/article/VLOOKUP-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1
I suggest you create the following in a sub sheet
columnA
1
2
3
columnB
Diamond
Mounting
Gemstone
in your data sheet, columnP use vlookup function to find the value according to columnN. When you are using VLOOKUP, be aware of the difference between Ralative Row/Column and Absolute Reference
VLOOKUP function
https://support.office.com/en-gb/article/VLOOKUP-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1