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.
That definitely looks like what I'd like to do!Unfortunately I didn't see anything in that file that states how I would go about setting this up. I can certainly make the table, but how would I link the spreadsheets so that typing in one brings up information from the other?
Oh I see what you did there! Sorry I didn't know you included an entire file with everything. I thought it was just an example. Thank you I think this will help!