Forum Discussion
formula help
Hi Everyone, I'm looking for the right formula here. In one column I have the product type which is either Diesel or Def. In another column, I have the number of gallons used for that product. And...
Let's say product type is in A2 and down, and gallons used in B2 and down.
Create a small lookup table, for example in K1:L3
The formula in C2 is
=B2*VLOOKUP(A2,$K$2:$L$3,2,FALSE)This can be filled down.