Hi All,
I have one table with Item#, order# and Sales. In another spreadsheet I am
creating table for each item seperately to see the sales. When I use vlookup,
it doesnt work because source has same item multiple times. I am changing the
range by one raw down once I do vlookup to avoid the first data taken but
then if lookup value is repeating at the end then it will pull so many times.

If you dont understand the question. Please try to use vlookup from a table
where there is one item more than once. and use vlook up for more than once.

Thanks,
Sean