Hi

I have been struggling to find a a quick way of referencing two spreadsheets to find matches on rows. When there is a match i want to bring the value of another cell on the same row across!

We are often trying to match spreadsheets of customers purchasing requirements against out current stock holding. They will send us a list of the manufacturer part numbers they are looking for and how many. I need to reference this against my stock list, find out how many i have and the price.

Is this possible?