Display a cell value from another cell based on a a certain criteria

[AmarW]

Hello everyone!

As I am fairly new to Excel I am having issues with the following thing I am trying to do. I will try to explain it as clearly as possible.

I have 2 different cells with a certain value (for example: A & B) and 1 cell (C) where I can fill in 1 option of the 3. (TOW, LDW and ZFW).

The thing is, I have 1 cell (D) where I want it to display the value from either A or B or no value at all. So if I select TOW in cell C I want it to display the value from cell A in cell D. And when I select LDW I want it to show the value from B in D. and when I select ZFW, no value at all.

Is there any way of doing this? Thanks in advance for the help!

Kind regards,

Amar

[kvsrinivasamurthy]

Formula in D1
=IF(C3="TOW",A1,IF(C3="LDW",B1,""))

[Pete_UK]

Put this1:

=IF(C1="TOW",A1,IF(C1="LDW",B1,""))

You will probably need to use semicolons instead of commas to separate the terms.

Hope this helps.

Pete

[jayajaya_4]

hello,

I had worked with your example..see if it works for u

Regards,
Jaya

[AmarW]

Thanks! I am getting close now. The only thing is, if I select ZFW I won't get a 0 as a value... so what should I add to get 0 in cell D when I select ZFW?

[jayajaya_4]

Use this

=IF(C1="TOW",A1,IF(C1="LDW",B1,IF(C1="ZFW","0")))

[Pete_UK]

Change the "" at the end of the formula to 0 instead:

=IF(C1="TOW",A1,IF(C1="LDW",B1,0))

Hope this helps.

Pete

[AmarW]

Ah yes, thank you guys so much. Its very logical but 2 hours of sleep doesn't help with clear thinking. I kept getting errors probably due to an error in the spacing/semicolons.

Again, really appreciate it!

[Pete_UK]

Glad to be of help - thanks for the rep.

Pete