Test if a number match one of a range

[BRISBANEBOB]

How can I test if a number matches another number within a range? I've attached a sample spreadsheet.

Thanks

[shg]

=ISNUMBER(MATCH(somevalue, somerange, 0))

[protonLeah]

Try:

Please Login or Register  to view this content.

[BRISBANEBOB]

Thanks guys - much appreciated

[shg]

BB, please mark the thread as solved?



How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save