multiple possible result in one cell...

[doudou]

Hi,
In a IF function, I want to do something like this:
IF(D476="s OR v OR v1 OR vp OR h";tab!$B$8;tab!$B$9))
So, for certains results, it has to retrieve a data, for the others
another one.
Thanks for your help...

 

[Biff]

Hi!

Try this:

=IF(OR(D476={"s","v","v1","vp","h"}),tab!$B$8,tab!$B$9)

Replace the commas with semicolons if that's what you use as separator in
your version of Excel.

Biff

 

[doudou]

thanks, works perfectly, indeed with another separator.
chears

 

[Biff]

You're welcome! Thanks for the feedback.

Biff