movieprodw
asked on
Find matching sku put qty in column next to it
Hello,
Is it possible to grab the sku in column E on SHEET 'skus' and check it against the column A on SHEET 'qty' if it finds a match then it grabs the quantity from column E and puts it next to the matching sku on sheet 'skus'?
I have attached the sample doc.
Thanks for any help, this would save me hours of manually searching hundreds of rows.
Matt
sample-data.xlsx
Is it possible to grab the sku in column E on SHEET 'skus' and check it against the column A on SHEET 'qty' if it finds a match then it grabs the quantity from column E and puts it next to the matching sku on sheet 'skus'?
I have attached the sample doc.
Thanks for any help, this would save me hours of manually searching hundreds of rows.
Matt
sample-data.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER