Hi,
I have one column on my sheet with a long list of part numbers (PartNum). I populated into a 2-dimen array that contains the part numbers and another set of values (Cost). Is there a way to paste into a 2nd col. the Cost only if the part numbers in the array match up with the ones in the sheet? I don't want to use a loop to match each one by one since it takes too much timePlease help
Could you not just use a VLOOKUP?
how do I use it ? thanksOriginally Posted by Norie
Like this
New to the forum? Check out our Introductions section to get to know some of the members here. Feel free to tell us a little about yourself as well.
Posting Permissions
Reply With Quote
