Instert multiple if conditions in cells

[bluepomme]

Hello

I would need some help i have cell I2 , would like insert multiple if conditions based on the selection made in cell H2.

Something like this

Please Login or Register  to view this content.

i add book to show

Libro1.xlsm

thank you

[Fluff13]

How about

Please Login or Register  to view this content.

[bluepomme]

thank you for your promt response

i tested your formula but only worked on the last one, the: IF(H2="SIN_MEGAPASS",Hoja2!B3,"" the first two still not working since it should take the values from the second worksheet

Attachment 632195 Attachment 632196

[Fluff13]

You're dropdown values do not match your formula conditions, try

Please Login or Register  to view this content.

But you have a space after "MEGAPASS_CENA" on Hoja2

[bluepomme]

oh can't believe it was just of that space ... my mistake sorry
and yes it works fine your are a great help i very appreciate

[Fluff13]

You're welcome & thanks for the feedback