Need a more detailed explanation. Sounds like you want to return more than
one value. Post the formula you're using.

--
Biff
Microsoft Excel MVP


"Automate" wrote in message
...
I try to look for solution to automate using VLOOKUP to match the "part
number" and copy series data from another spreadsheet to working
spreadsheet.
I have try the VLOOKUP and MATCH but only single value allow to copy.
Pls adv......chew