ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Linking Text to a numerical value (https://www.excelbanter.com/excel-discussion-misc-queries/191694-linking-text-numerical-value.html)

RickE

Linking Text to a numerical value
 
Is there some way for me to type text in a cell, and that will generate a
price for that item inside another cell? This way I can just type my items in
my materials column, and it will automatically populate in my price column.

--
Thank you,

Rick

Evan Weiner

Linking Text to a numerical value
 
Sounds like a VLOOKUP job. See the help.

"RickE" wrote:

Is there some way for me to type text in a cell, and that will generate a
price for that item inside another cell? This way I can just type my items in
my materials column, and it will automatically populate in my price column.

--
Thank you,

Rick



All times are GMT +1. The time now is 04:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com