Forum Discussion
Formula to calculate value based on multiple cells
Hey all, another question for you. I just learned about vlookup to bring cell values based on input in another cell, and would like suggestions for the following: I enter an item name in A2, vlo...
Try this in C2, then copy to D2:
=$B2*
VLOOKUP($A2,$L$2:$N$100,
COLUMN()-1,0)
=$B2*
VLOOKUP($A2,$L$2:$N$100,
COLUMN()-1,0)