outcome of a cell dependent an value of a set of 3 cells

[matwalker]

Hi first off thank you for taking the time to look at this.

I have a sheet which is a slection sheet of equipment (1(no numerical value) in the box means that this equipment is included)

What im trying to do is

If cell Access!C5=1 then cell summary = door handle

so i used an if statement like this

=IF(Access!C5=1,"door handle","") works great

problem i have is that i have 3 possible cells that will fill the cell on the summary sheet

c5 c6 and c7

if a 1 is in c5 then it's a door handle =IF(Access!C5=1,"door handle","")
if a 1 is in c6 then it's a pull lever =IF(Access!C6=1,"Pull lever","")
if a 1 in in c7 then it's a blank plate =IF(Access!C7=1,"Blank plate","")

now i get the if statement to work for each one seperatly but when i try to combine all 3 in one cell i get an error.

The answer can only be one of the 3


please can anybody either point me in the right direction or add the missing bits


thank you

[Ace_XL]

Try

Please Login or Register  to view this content.

[dredwolf]

Which one has priority ?
if the blank plate is highest then something like this :

Please Login or Register  to view this content.

Hope this helps

[Pete_UK]

Do you mean that you want one formula that combines each of those conditions? Like this:

=IF(Access!C5=1,"door handle",IF(Access!C6=1,"Pull lever",IF(Access!C7=1,"Blank plate","")))

Here's another way:

=INDEX({"door handle","Pull lever","Blank plate"},MATCH(1,C5:C7,0))

Hope this helps.

Pete

[matwalker]

Hi Ace,

Thank you works great


pete/dredwolf thanks ace soloution worked thank you for your replys




Matt