IF function in a range of cells

[Drake Dredgewater]

Hi guys,

I want to ask Excel to give me a value if a condition is met in a range of cells. So for example in cells I7:I9 I have values of 'Car' (I7), 'Truck' (I8) and 'Bike' (I9). The criterium I am looking for is "Truck" which I entered in I:17 so I can change it to whatever other criterium I want. Since in my example I have '30' Trucks, I need Excel to show me this result which should be equal to the J8 and is the middle value of cells in the range J7:J9.

I tried this formula:

{=IF(I7:I9=I17,J7:J9,0)}

For some reason this doesnt work.

Any ideas?

Thnx!!

[etaf]

what do you want to put in the cell?

you can use a countif()

=if(countif(i7:i9,"truck")>0, "in list", "not in list")

[Tony Valko]

Maybe this...

=VLOOKUP(I17,I7:J9,2,0)

[Drake Dredgewater]

I tried the Vloopup function; it works amazingly! Thank you so much!

[Drake Dredgewater]

Thanks! Amazing, this has helped alot!

[Drake Dredgewater]

Thanks for helping; i don't want to put in words however but rather refer to cells.

[Tony Valko]

You're welcome. Thanks for the feedback!