Mar 25 2021 05:08 AM
Please assist.
I need to do VLOOKUP in a document with 2 pricelists.
I have 4 columns.
Part number (manual entry) Description (vlookup) Pricelist (NEED TO CHOOSE BETWEEN 2) Discount (VLOOKUP)
The costing sheet looks for data from 2 different sheets, within the same document.
Discount looks vlookup info from a sheet
I need the pricelist column, to look for data from another sheet, based on the result achieved in discount column.
EXAMPLE
ABC gets 25% discount, the price in the costing sheet, needs to come from column 5 from pricelist sheet
XYZ gets no discount, the price in the costing sheet (SAME COLUMN), needs to come from column 4 from the pricelist sheet
thank you for your time.
Mar 25 2021 05:53 AM
Mar 25 2021 06:41 AM
@Subodh_Tiwari_sktneer Hi, thank you, attached simplified version of the document.
4 sheets
1st sheet cover and customer view
2nd costing sheet to place the formula in the columns
3rd price list with 2 columns, yellow is reseller the other list pricing
4th sheet customer info to allocate data to 1st and 2nd page regarding discount
Discount % will determine which column the price will come from.
Mar 25 2021 07:31 AM
Mar 25 2021 07:57 AM
Mar 25 2021 08:17 AM