Thanks for the quick response but I'm not sure I gave you all the info
needed. . . I will be typing in a Buyer's Number in a Live Auction on Friday
into an existing table containing auction item information. In the past,
I've typed out all of the Buyer Information on the fly (which is already
located in another table). I need to be able to add Buyer Information into 6
or so rows at a time and then print (a contract which I have merged the data
into Word). I have never used VLookup. The Buyer information is listed in
row format in another table in 8+ cells, e.g.
101 John Smith Address City State Zip Etc.
102 Ted Johns Etc.

What is the difference between VLookup and HLookup (I assume vertical and
horizontal)? Will I type in the Buyer's # or "look i up from a pick-list"
after completing the VLookup? Thanks again.


"David Adamson" wrote:

Vlookup will do it for you all

Just use a loop. The following should but not tested. Find the value in
the table and copy the data for 3 columns.

If you need it to do a whole table then put a loop in for the value to find
(Find_Value) i.e. .cells(i+c,1)


-----------------
Set Data_TABLE = Range(.Cells(5,1 ), .Cells(Rows.Count, 9).End(xlUp))
'.Select

'the information you wish to find (range "a1")
Find_Value= .cells(1,1) 'a1

'Result is the value to be returned
'explination of VLookup(find thisvalue, in this table, column to lookup,
match type)

For i = 1 to 3

Result = Application.VLookup(Find_Value, DATA_Table, 4+i, 0)

'paste result into ("b1")
..Cells(1,2+i) = Result

Next i
------------
"TeeGee" wrote in message
...
Is it possible to have Excel "lookup" a value from another table and "fill
in" several cells according to the value found (similar to the lookup
table
feature in Access)? E.G. Look up and fill in Buyer's # found in another
table and fill in Buyer's Name, Address, Phone, Etc. accordingly.

I don't want to switch my data to Access if I don't need to.

Desparate . . .