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
cebassoAsked:
Who is Participating?
 
barry houdiniCommented:
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
 
Eric ZwiekhorstSAP Business ConsultantCommented:
=if(A1=c2,D2,if(A1=C1,d1,""))


kr
Eric
0
 
SiddharthRoutCommented:
=If(A1=C1,D1,if(A1=C2,D2,""))

Sid
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Eric ZwiekhorstSAP Business ConsultantCommented:
paste this in B1

kr Eric
0
 
SiddharthRoutCommented:
=If(A1=C1,D1,if(A1=C2,D2,""))

Sid
0
 
sah18Commented:
Place this in B1:

=VLOOKUP(A1,C:D,2)

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

Sid
0
 
Eric ZwiekhorstSAP Business ConsultantCommented:
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
 
SiddharthRoutCommented:
cebasso: Please ignore ID: 35008120

There was some problem with the browser...

Sid
0
 
barry houdiniCommented:
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
 
Eric ZwiekhorstSAP Business ConsultantCommented:
He Cebasso,

Do you understand the function if the IF statement?

=IF(true or false statement, value if tru,value if false)
0
 
SiddharthRoutCommented:
Ah. I see what you mean....

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

Sid
0
 
cebassoAuthor 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
 
cebassoAuthor 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.

All Courses

From novice to tech pro — start learning today.