Default Re: Vlookup
Sheet 1
Column A - Price
Column B - Product name
Sheet 1 is the lookup sheet in cell C3 - I want to bring back if column B matches column A on sheet 2 and if the number in column a in sheet 1 falls between two numbers in sheet 2 Theae are column C and D with c being the high number and D being the low. then to bring back column b of sheet 2.
In column d3 in sheet 1 I want to match column b in sheet 2 to column a in sheet 1 falls between column c and d in sheet 2 and bring back as agreed or disagreed.
Sheet 2 -
Column A - Name of product
Column B - Code
Column C - Price High
Column D - Price Low
Sheet 1
Column A - Price
Column B - Product name
Sheet 1 is the lookup sheet in cell C3 - I want to bring back if column B matches column A on sheet 2 and if the number in column a in sheet 1 falls between two numbers in sheet 2 Theae are column C and D with c being the high number and D being the low. then to bring back column b of sheet 2.
In column d3 in sheet 1 I want to match column b in sheet 2 to column a in sheet 1 falls between column c and d in sheet 2 and bring back as agreed or disagreed.
Sheet 2 -
Column A - Name of product
Column B - Code
Column C - Price High
Column D - Price Low
