|
SE WI | Could use the VLOOKUP function.
Using your example sheet, go to the B4 cell where you want the price to populate, type the function =VLOOKUP(A4,Sheet2!$A4:$B13,2)
As you go down the sheet in column B the formula will stay the same except the first value will change (A5, A6, A7, etc.) because that's the input that the formula will be looking for to return the price value you're looking for.
Edited by mmbdgr 9/6/2019 19:49
| |
|