Let's say your table starts at Q1 and you have a Match formula in A1 that
returns the offset from Q1 that the current item matches. Say that item is
in Q10 so the Match formula returns 10. If you wanted the item next door in
R10 you could use this formula:

=OFFSET(Q1,A1-1,1)

--
Jim
"Jaybird" wrote in message
...
| I've read some tantalizing clues, but haven't yet found a solution
| that works... I'm trying to use match and offset to autofill cells
| with information on one worksheet from another. What I have is
| worksheet one with a large list of information, several columns worth
| and many, many rows. The unique identifier is in, say column Q. By
| scanning a barcode onto a cell in worksheet 2 I can determine which
| row of column Q contains that particular unique barcode using the
| match function. What I'd like to do is to autofill the subsequent
| cells in worksheet 2 with the information on that particular row of
| worksheet1 using some combination of match and offset, but I can't
| seem to get the syntax right. Does anyone have a clue?