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


--
memac19
------------------------------------------------------------------------
memac19's Profile: http://www.excelforum.com/member.php...fo&userid=5354
View this thread: http://www.excelforum.com/showthread...hreadid=477988

what do you mean apply $???

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

--
Regards,
Tom Ogilvy

"memac19" wrote in
message ...

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


--
memac19
------------------------------------------------------------------------
memac19's Profile:
http://www.excelforum.com/member.php...fo&userid=5354
View this thread: http://www.excelforum.com/showthread...hreadid=477988

the question marks would be a number $500


--
memac19
------------------------------------------------------------------------
memac19's Profile: http://www.excelforum.com/member.php...fo&userid=5354
View this thread: http://www.excelforum.com/showthread...hreadid=477988