Hi,
I want to do VLOOKUP on sheet1 to Sheet2 and get Price. But I want to see the result as show in sheet1. Saying that, VLOOKUP will pick the data where there is incremental.
This formula doesn't meet my requirements.
=VLOOKUP(A3,Sheet2!A:B,2,FALSE)
Any idea to achieve the goal?
I want to do VLOOKUP on sheet1 to Sheet2 and get Price. But I want to see the result as show in sheet1. Saying that, VLOOKUP will pick the data where there is incremental.
This formula doesn't meet my requirements.
=VLOOKUP(A3,Sheet2!A:B,2,FALSE)
Any idea to achieve the goal?