View Single Post
  #1   Report Post  
memac19
 
Posts: n/a
Default Vlookup and if statements


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