Macro or Lookup? Not sure where to start.

[Guest]

I have created two worksheets:
1) Auction Items
Item# Table# Location# ItemDescription WinBid are the headers of the data.
2) Bidders
Bidder# FirstName LastName

I would like to be able to create a macro or something that will allow me to
enter the item#, bidder# and winning bid price and have a sheet filled with.

ie.
Item# 2 (Handcrafted Table)
Bidder# 12 (John Doe)
Winning Bid $250

Can excel pull from two sheets and created another sheet with all the final
details?
I am a little new to excel (version 2000) it is the only tool/application
available to us at this time. If anyone can point me in the right direction
it will be a great help.
Thanks
dD

 

[Guest]

DoubleD;

Create your table thusly(suggested format)

First Last ID Item Table Location ItemDesc Bid Concatenate

Enter your bidder information. In the Concatenate field type the following;

=concatenate(a1," ",b1)

This will combine the bidders first and last name. Drag this formula down
the column as needed. In cell J2 type;

=max(h2:h10)

Create a form that has fields named what you like and add pics, etc. Now,
Next to the cell that says name enter this:

=IF(LOOKUP(J2,H2:H10)=J2,LOOKUP(J2,H2:H10,I2:I10),"")

This is your first and last name. In the cell next to Bidder# type;

=IF(LOOKUP(J2,H2:H10)=J2,LOOKUP(J2,H2:H10,c2:c10),"")

This is your Bidder #. Next to the cell that is labeled Winning Bid type;

=j2

I think that's right. Post back if it throws an error.

God Bless

Frank Pytel