Vlookup and if statements

  • Thread starter Thread starter memac19
  • Start date Start date
M

memac19

I am having trouble using the Vlookup function and if statements
together. (I thinks these are the function I need)
My problem is that I need a cell to lookup text in one cell and then I
need it to go to another cell were the value has to fall into a certain
range.
Ex.
look up cell c44 if it is ABC apply $??? NOW depending on the value of
cell D44 I need it to apply a certain value to the cell in question.

Not the best of explanation, but if someone can help that would be
great.

thanks
 
what do you mean apply $???

=if(vlookup(val,Range,2,False)="ABC","$????","Criteria not met")
 
Back
Top