if function help

[Haz]

hi,
I am looking for a possible If Function that will read col E, and if it is
East/west or tower it will divide the adjucent cell in Col f (15) by what I
want east/west and tower to represent. I have given this below. I do not want
to type in the 2,1.86 and 2. ideally just represent east/west and tower in
cells as E - W -T and do this calc.


east =2 15
west=1.86 16
tower=2 17

Hope this makes sense
Thanks

Haz

 

[Pete_UK]

Something like:

=F15/INDEX({2,1.86,2},MATCH(E15,{"E","W","T"},0))

Hope this helps.

Pete

 

[Pete_UK]

You have an answer elsewhere - please do not multi post.

Pete

 

[Pete_UK]

Sorry, my mistake.

Pete

You have an answer elsewhere - please do not multi post.

Pete






- Show quoted text -