If varaible is in list - formula

[jaryszek]

Hi,

i want to calculate something like here:

Screenshot_15.png

So if "Topo1" in a list , do something.
How can i write this in formula?

ah sorry there should be If Topo1, Topo2, Topo3 and so on.

Best,
Jacek

[Pete_UK]

How about this in C3:

=IF(COUNTIF($H$1:$H$2,B3),"Yes","No")

then copy down. You could also do it using MATCH:

=IF(ISNUMBER(MATCH(B3,$H$1:$H$2,0)),"Yes","No")

Hope this helps.

Pete

[Roel Jongman]

Try this formula in cell C3

Please Login or Register  to view this content.

so use a basic vlookup function to find the value. then use a boolean function ISNA to test if a result was found. then use if to show "No" if ISNA finds a #N/A error (no result found)

[Greg M]

Hi there,

See if the following User-Defined Function does what you need:

Please Login or Register  to view this content.

The highlighted value may be altered to suit your requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M

[jaryszek]

Hi Guys,

thank you very much!

I used Pete_UK formula.
I do not like UDf function on tables because once i had issues with recalculating it all the time from different macros triggered.

Best,
Jacek

[Pete_UK]

Glad it (or they) worked for you - thanks for the rep.

Pete

[Greg M]

Hi again,

Many thanks for your feedback.

Glad to hear that things are working correctly for you now.

Regards,

Greg M