Need help merging two Excel spreadsheets

[pheffley]

I have two spreadsheets. Each sheet shares a common field that serves as an ID tag (mixed text and numbers). Sheet1 has just this ID and a dollar value associated to it. Sheet2 has many more fields but less total records compared to Sheet1. I need to take the dollar amount in Sheet1 and insert it into Sheet2 while matching the ID tag. I also need to set up some logic for this. If there are duplicate ID tags in Sheet1, I should use the one with the lowest dollar value; and if there are no matching ID tags in Sheet2 the dollar value should be null in Sheet2 after the merge.

I can do this using Access, but can this be done in Excel? If so, how?

Thanks.

 

[pheffley]

Actually, I can join the two data sets in Access, but I don't get all of the results from Sheet2 back, only the ones that match the ID tag. I need to return all results from Sheet2 and set the dollar value to Null if there is no match. So I guess I need to know how to do it in both Access and Excel.

Thanks.

 

[pheffley]

ttt