# Calculating one field with multiples getting data from another

Hello,

Can somebody tell me how to make the following logical sentence

Example

B1 = IF A1 = C1 THEN B1 will be = D1 but if A1 = C2 THEN B1 will be = D2 understand?

in A1 i'll type some value, if its equal C1,C2,C3 for example, B1 will be = D(RESPECTIVE SEQUENCE FROM C)

Some idea?

Regards
LVL 4
###### Who is Participating?

Commented:
also in the last part C3 is mentioned so I think the Asker wants to look beyond row 2. VLOOKUP will work even for 2 rows but is certainly the correct option for more, I think

....I said use FALSE but then used zero, they do the same, so it can be either

=VLOOKUP(A1,C:D,2,0)

or

=VLOOKUP(A1,C:D,2,FALSE)

regards, barry
0

=if(A1=c2,D2,if(A1=C1,d1,""))

kr
Eric
0

Commented:
=If(A1=C1,D1,if(A1=C2,D2,""))

Sid
0

paste this in B1

kr Eric
0

Commented:
=If(A1=C1,D1,if(A1=C2,D2,""))

Sid
0

Commented:
Place this in B1:

=VLOOKUP(A1,C:D,2)

Note:  for this to work, your column C must be in ascending sort order.
0

Commented:
Too Slow...

Sid
0

He Sid I think the A1=C2 has priority over A1=C1?

If it is so mine is right one if not yours is the right one....

kr

Eric
0

Commented:

There was some problem with the browser...

Sid
0

Commented:
I'd go with the VLOOKUP, but you need FALSE as the 4th argument, i.e. iin B1

VLOOKUP(A1,C:D,2,0)

nothing needs sorting

regards, barry
0

He Cebasso,

Do you understand the function if the IF statement?

=IF(true or false statement, value if tru,value if false)
0

Commented:
Ah. I see what you mean....

Yes you are right. I didn't quite catch the priority part.

Sid
0

Author Commented:
He Cebasso,
Do you understand the function if the IF statement?
=IF(true or false statement, value if tru,value if false)

Yeap, i understand... i know about logical sentences except for Excel, i dont know how to interpret it hehe
0

Author Commented:
Perfect! Thanks everybody!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.