is there a way to do Match by various value?

February 27, 2013 at 01:22:00
Specs: Windows 7
i have 2 sets of data,

Set1 contains 40 different codes
Set2 contains full year data and all different codes.

i only want to pick out these 40 codes in Set2,
i thinking to do MATCH, but match seems to be only able to do 1 value match....
out of idea, please help
thanks


See More: is there a way to do Match by various value?

Report •

#1
February 27, 2013 at 04:27:45
I'm not clear on what you are trying to do. Have you looked at the Advanced Filter feature? See here:

http://office.microsoft.com/en-us/e...

It might help if you posted an example of your data with an explanation of what you are trying to do. Before posting example data, please click on the following line and read the instructions found via that link.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
February 27, 2013 at 18:02:11
solved!
thank you very much!

Report •
Related Solutions


Ask Question