enter a value where i want it to lookup

N

Neuther

I hope i can explain this ok. I have a # lets say 2 and sometimes
want it to be worth 2 pts but others i want it to be worth half that
pt and sometimes i don't want it to be anything at all 0

So, i got half way there w/ a vlookup. in cell a1 i put a 2, then i
a2 threw d6 i have either 1, 2, or 0. Then in cell a7 i have lets sa
D, and my table is like

a=vlookup(a1,a2:d6,2,false
 
F

Frank Kabel

Hi
not really sure what you're trying to do. How should the
formula identify which value you want for cell A1. Maybe
you can give some example data of your table and describe
HOW to define which value should be returned.
 
J

JulieD

Hi

sorry don't really understand what you're after - especially how you use
from A2:D6 to store only three numbers (1,2,0)

but this following example may help - if you have
A B C D
1 Number Bill Bob Steve
2 1 .5 1 0
3 2 1 2 0
4 3 1.5 3 0

where Bill wants half the original number, Bob wants the original number and
Steve always wants 0
then in A7 you chould type either Bill, Bob or Steve
and in B7 you could type the number you wanted to lookup up
and in C7 you could have the following VLOOKUP

=VLOOKUP(B7,A1:D4,IF(A7="Bill",2,IF(A7="Bob",3,4)),False)

alternatively you could do this
=IF(A7="Bill",B7*.5,IF(A7="Bob",B7,0))
and not use a lookup at all

Please get back to me if i've misunderstood what you're after.

Regards
JulieD
 
Top