=IF and VLOOKUP

T

Theo

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!
 
C

chris

ok what about this,

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

Let me know if that works
 

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

Similar Threads

IF statement with multiple VLOOKUPs 0
VLOOKUP isn't working properly in Excel on Mac 1
vlookup returning #value! 3
=IF(ISERROR(VLOOKUP(A3,contacts!B:I,5,FALSE)), " ", VLOOKUP(A3,con 4
excel formula is returning incorrect values 0
Combining IF and VLOOKUP 2
Macro 3
How to combine IF statement and Vlookup function? 2

Top