if formula

[krzysq]

I'm sure for all of you its easy but I don't know how to simplify this formula: =IF('Personal Details'!AB58="female waxing", 'Personal Details'!B58, IF('Personal Details'!AB59="female waxing", 'Personal Details'!B59, IF('Personal Details'!AB60="Female Waxing", 'Personal Details'!B60,IF('Personal Details'!AB61="Female Waxing", 'Personal Details'!B61,"")))) ???? Thank you

 

[pgc01]

Hi
Welcome to the board

Try:

=IFERROR(INDEX(B58:B61,MATCH("female waxing",'Personal Details'!AB58:AB61,0)),"")

 

[pgc01]

Sorry, forgot the worksheet name in the first reference:

=IFERROR(INDEX('Personal Details'!B58:B61,MATCH("female waxing",'Personal Details'!AB58:AB61,0)),"")

 

[krzysq]

Sorry, forgot the worksheet name in the first reference:

=IFERROR(INDEX('Personal Details'!B58:B61,MATCH("female waxing",'Personal Details'!AB58:AB61,0)),"")

Thank you this works perfectly. Do you know what should I put in the cell below the one I put your formula, so its not repeating value???

 

[Robert Mika]

=IFERROR(INDEX('personal details'!$B$58:$B$61,SMALL(IF('personal details'!$AB$58:$AB$61="female waxing",ROW('personal details'!$AB$58:$AB$61)-ROW('personal details'!$B$58)+1),ROWS($A$1:A1))),"")
Confirm Control+shift+enter

 

[krzysq]

Thank you

 

[Robert Mika]

Thank you

You are welcome