Thread: =IF and VLOOKUP
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
theo theo is offline
external usenet poster
 
Posts: 66
Default =IF and VLOOKUP

Dumb question, but here goes.

I'm trying to combine two functions and really just guessing how to combine
the two -

=IF(C129="Low","(=VLOOKUP(C102, Sheet4!$E$2:F$38, 2, FALSE))","
(=VLOOKUP(C102,Sheet4!$A$2:B$38,2,FALSE))")

That was my feeble guess, and naturally it does not work .....

Cell C129 Can be "Low" or something Else (not blank).
If it's Low, I want to take the score in C102 and go get the results in the
first VLOOKUP statement.
If it's not Low, I want to take the score in C102 and go get the (different
results) in the second VLOOKUP statement.
IfC129 is blank, then I don't want any result.

I've searched for a while and can't find what I'm looking for ......
Thanks guys!