Search for values and return true or false value

Hi,

I would like some help to produce some vba code to perform the following action:

1)search sheet 1 for 300 numeric values that are listed in column A sheet 2

2)Each value in column A sheet 2, if found in sheet sheet 1, should return a True or False value in Column B sheet 2.

(please note the values may occur more than once in sheet one)

I hope this is clear. Any questions please ask.


Thanks in advanced for any help.

Maybe:

Please Login or Register  to view this content.

Originally Posted by Mumps1

You didn't state if the values in sheet 1 are in column A or could be anywhere on the sheet. If the latter, then try:

Please Login or Register  to view this content.

Amazing response guys! Really helpful.

i have gone with the code above as the data can indeed appear anywhere in sheet1.

However, i now have an issue in that the cells that contain the values i am searching for also contain other text.

for example, cell A1 contains:

BOW PIONE 9990148.001 *4013860 REFOR F/P 680 000.000M F 00.01 0000001.000 VAS AROMS c_IPBrent Jan15 Close +00.0 Dec12-15 00.000B F 0.000 0.00 (608.54)R


so, is it possible for the search to pick the specific value from each cell, for example, "9990148.001" from the above example?

thanks in advance

Originally Posted by Mumps1

Just change xlWhole to xlPart.

Brilliant! thanks again for everyone's help!