Excel formula - Help or suggestion to get a solution

[Victor87]

Hi All,

I am trying get a value which is on column c, based on conditions. Where I have 3 values (0,1,2) I want formula to return.

I have tried using IF, OR, AND functions. but, I feel like I am missing something.
I would appreciate if you could help/ suggest towards getting my solution.

I am using excel 2013

[TABLE="width: 261"]
<!--StartFragment--> <colgroup><col width="87" span="3" style="width:65pt"> </colgroup><tbody>[TR]
[TD="width: 87"]Seattle [/TD]
[TD="width: 87"]BUS[/TD]
[TD="width: 87, align: right"]1[/TD]
[/TR]
[TR]
[TD]SFO[/TD]
[TD]Walk[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]LA[/TD]
[TD]Train[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="class: xl64"]lA[/TD]
[TD="class: xl64"]bUS[/TD]
[TD="class: xl64, align: right"]2[/TD]
[/TR]
[TR]
[TD="class: xl65"]seattle [/TD]
[TD="class: xl65"]bUS[/TD]
[TD="class: xl65, align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl64"]SFO[/TD]
[TD="class: xl64"]bUS[/TD]
[TD="class: xl64, align: right"]2[/TD]
[/TR]
[TR]
[TD]SFO[/TD]
[TD]train[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]Seattle [/TD]
[TD]train[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]Seattle [/TD]
[TD]train[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]Seattle [/TD]
[TD]train[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]Seattle [/TD]
[TD]walk[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Seattle [/TD]
[TD]walk[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Seattle [/TD]
[TD]walk[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63"]SFO[/TD]
[TD]BUS[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="class: xl63"]LA[/TD]
[TD]bUS[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="class: xl63"]SFO[/TD]
[TD]bUS[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="class: xl63"]Seattle [/TD]
[TD]train[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="class: xl63"]SFO[/TD]
[TD]train[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="class: xl63"]SFO[/TD]
[TD]train[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="class: xl63"]SFO[/TD]
[TD]walk[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="class: xl63"]lA[/TD]
[TD]walk[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="class: xl63"]lA[/TD]
[TD]wb[/TD]
[TD="align: right"]2[/TD]
[/TR]
<!--EndFragment--></tbody>[/TABLE]

 

[jasonb75]

You've shown us the data sample and given the result you expect, but not the reason / logic behind selecting the value.

I'm going to guess that you want to enter a city and mode of transport then get the corresponding value.

Try

=LOOKUP(2,1/IF(A2:A20="Seattle",B2:B20="train"),C2:C20)

Confirmed as an array formula using Shift Ctrl Enter.