PDA

View Full Version : Paste into column only if criteria met



azcalv
07-22-2006, 10:35 AM
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 time :think: Please help :bow:

Norie
07-22-2006, 11:36 AM
Could you not just use a VLOOKUP?

azcalv
07-22-2006, 04:02 PM
Could you not just use a VLOOKUP?

how do I use it ? thanks

malik641
07-22-2006, 10:36 PM
Like this :thumb