Forum Discussion
Pick & Choose numbers from connected Excel File
Hello, I am not 100% familiar with Excel, I'd say I'm a beginner. So laymen terms is great. My issue is the company I work for has an excel spreadsheet with all of our products part #s and pr...
Hello, it is possible. I attached an excel file that I used VLOOKUP to solve
There are two sheets: Customer Quite and General Price List
In the Customer Quote sheet, there are Product ID, Qty, Product Description, Price and Total Columns
In the General Price List, we have the same column with many data.
To get the corresponding Product Description in General Price List sheet, I used VLOOKUP and deployed the Product ID as the lookup value.
There are two sheets: Customer Quite and General Price List
In the Customer Quote sheet, there are Product ID, Qty, Product Description, Price and Total Columns
In the General Price List, we have the same column with many data.
To get the corresponding Product Description in General Price List sheet, I used VLOOKUP and deployed the Product ID as the lookup value.