VBA newbie: How to test the existence of a string in a vector?

  • Thread starter Thread starter Frank Krogh
  • Start date Start date
F

Frank Krogh

I try to test if a string value in a cell is present in a vector/range:

CountyNo
0120
0230
1542
2359
....

The test result could be either boolean or a digit.

Which formula could be applied? Is the LOOKUP formula an alternative?

Thanks for suggestions.


Frank Krogh
 
Frank,

You could use MATCH

=NOT(ISNA(MATCH("0120",A1:A6,0)))

which returns TRUE/FALSE
--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Array Formulas in VBA 17
VBA - How to test if a text box is present on the sheet or not? 1
Newbie: how to show the checked symbol in a label control 1
How do I test whether a string is a valid cell reference? 5
How to change date format in VBA 8
Finding the maximum in an array of strings (Excel VBA) 6
VBA test for the existance of a worksheet. 4
How best to parse string lists of numbers 7

Back
Top