It has been a while since I have worked with functions in Excel. I do not
remember the best way of designing a formula for this problem. For a ball
and auction event, which raised about $100,000 for charity, each bidder (name)
was assigned a bidder number and table on one worksheet. The winning bids
(amounts) and bidders were entered on the second worksheet. Is there a way
to pull the names of the bidders from the first worksheet, in order to match
the winning bidder numbers to the winner names?

Thank you for any assistance in this problem.
GTT