Hello, I'm looking to code a sub that will find values in a sheet based on the part number and vendor number.
Part number = x
Vendor number = y
Result = z
When I click a command button the sub will:
1. search for variable X on another sheet in column A
2. once value is found in column A, the corresponding row in column B will be checked to see if it matches Y.
3. If it matches then store the result in z. If it doesn't match find the next match in A and repeat the check to see if B matches Y.
4. Loop until something is found that matches X and Y. If nothing is found then input "no results" into z.
Any suggestions?
Thanks!