oh wow thanks, i was so close from what i had i greatly appreciate it. One last question, what if my main inventory sheet is called Master same column A holds the master part numbers, but i use another sheet to scan called rcved and column A is where my bar codes are scanned into but the qty remains on my master sheet.

so we are using master sheet column a and column C but we need to compare sheet rcved column a to master a then update qty column c on the master