Windows XP Vlookup question

R

Ryk

Joined
Jul 18, 2008
Messages
6
Reaction score
0
Hoping to make a vlookup that will look in one of two ranges based on one cell being yes or no.

Our company has two charge out rates, general calls get one rate, longtime customers get a lower set rate.
So for instance,

Cell A1 says Longtime customer? and A2 has a yes/no dropdown.

Dave | $75 | $65
Tom | $75 | $65
Fred | $75 | $65
Tim | $75 | $65

My vlookup only sees the $75, how can I make it work to look in the $65 column if A2 is yes? And look in $75 if A2 is no?

Hope its clear enuf hehe

Thanx for any help
 
A simple IF statement would do this for you.

=IF(A2="yes",C2,D2)

C2 is the true result, D2 is the false result.
Remember.... speech marks are usually required for text when dealing with formulas.
You can then hide the cells you don't want shown.
I'll look into it further for you.... sorry but most of my experience in databases and forms is Access or SQL.
 
Guess I hadn't explained well...

The C2 being yes or no needed to change my vlookup for a different area....

So C2 can be yes or no...

Sheet Two
A3 B3 C3
Dave | $75 | $65
Tom | $75 | $65
Fred | $75 | $65
Tim | $75 | $65

My vlookup sees the $75 column
=(VLOOKUP(A11,$A$3:$B$9,2))
How would I incorperate your =IF(A2="yes",C2,D2)

Gonna toss out a newb try at it...
=IF(A2="yes"(VLOOKUP(A11,$A$3:$B$9,2)IF(A2="no"(VLOOKUP(A11,$A$3:$C$9,2)))

Bah that did nadda, but hope this better explains my problem....Thanx for replying


Ryk
 
Back
Top