INDEX/MATCH Help

Yeah the actual sheet is much more complicated though. All of this is for a college project by the way so I really do appreciate the help.

The data is under the Mannheim Car Data tab.
And I want to pull data from the Mannheim Car Data tab and place it in the Current Auction Database Tab.

So you hit run, type in 39 (the auction number), and it will begin to set up the Current Auction Database. The main thing I need to do is pull the WO from col. A of the Mannheim Car Data tab and place it in col D of the current Auction Database tab.

Matt

the formula that is currently in col D of the CurrentAuctionDatabase tab does not work