[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 234
  • Last Modified:

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
0
cebasso
Asked:
cebasso
  • 5
  • 4
  • 2
  • +2
1 Solution
 
Eric ZwiekhorstCommented:
=if(A1=c2,D2,if(A1=C1,d1,""))


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

Sid
0
 
Eric ZwiekhorstCommented:
paste this in B1

kr Eric
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
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 ZwiekhorstCommented:
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 ZwiekhorstCommented:
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
 
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
 
cebassoAuthor Commented:
Perfect! Thanks everybody!
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 5
  • 4
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now