Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
match and offset
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
OFFSET & MATCH | Excel Discussion (Misc queries) | |||
If And Match With a MAX and Offset | Excel Discussion (Misc queries) | |||
Match Offset by more than one value | Excel Discussion (Misc queries) | |||
Match Offset by more than one value | Excel Worksheet Functions | |||
Using Offset and Match | Excel Programming |