Vlookup and if statements

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
 
T

Tom Ogilvy

what do you mean apply $???

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top