Problem: Hide or show cells based on values in another cell

[JSysqa]

Hello

What i have functioning is as follows:


User selects "Problem X" from a list in cell Ax, receives a solution in cell Cx (Bx is used for dropdownarrow), confirms the solution helped with Yes or No in cell Dx. This results in either the value "1" or "2" showing up in cell Ex.

What I want to make functionable is as follows:

Cell Fx shows an alternative solution based on wich problem is chosen.(this is already the case). But i want to hide this solution when Ex is either blank or '1' and shows when Ex=2.

Can someone give me tips on how to do this or if there is a different way to achieve this? The workbook is attached with this message.

Kind regards.

[JohnTopley]

Try

=IF( E2<>2,"",VLOOKUP(A2,Blad2!A12:B20,COLUMN(Blad2!B12:B20)-COLUMN(Blad2!A12:B20)+1,0))

[JSysqa]

Thank you for your quick reply!

I tried using the formula you gave me but it gave me an error. It hints to this section of the formula(it was selected after the error)

Please Login or Register  to view this content.

[JSysqa]

Sorry, I replied in a wrong way. So this is for the notification.

[JohnTopley]

Try

=IF( E2<>2,"",Iferror(VLOOKUP(A2,Blad2!A12:B20,COLUMN(Blad2!B12:B20)-COLUMN(Blad2!A12:B20)+1,0),""))

[JSysqa]

Hi John,

Thank you for your time on this. I've tried your formula but it keeps giving me the following pop up
error1.png

I realize it's Dutch but the English version probably looks about the same. It's a generic error message directing me to the help function, function wizard or if i'm trying to type text in the cell instead of a formula, i shouldnt use (-) or (=)

Does this help in any understanding in what went wrong?

[JohnTopley]

Post the file with error condition: I can't view PNG images nor can anyone work with them.

[JSysqa]

I would if I could, but excel doesn't allow me to save the file when there is an error condition. To recreate the condition, you can paste the formula you gave me in to the file in de top post in cell F2

[JohnTopley]

Formula works for me: is it a matter of simply changing the commas to semi-colons in the formula?

=IF( E2<>2;"";IFERROR(VLOOKUP(A2;Blad2!A12:B20;COLUMN(Blad2!B12:B20)-COLUMN(Blad2!A12:B20)+1,0);""))

[JSysqa]

It worked! I have the Dutch version of outlook and I was under the assumption(!) that it rocognized the English terms IF/AND etc. But after switching them around it worked! Thanks a million for helping me!

[JohnTopley]

Glad it is resolved.

Could you please mark thread as solved ("Thread Tools" at top of first post).

Thank you.