Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with lookup code
Which lookup code do I use for the following
On a worksheet I have a row starting with a particular number, what I need to do is for excel to look for the exact match to the number in the range "a10:a20", When it finds the match in need the code to copy the entire row to that number in the range? some thing like this a b c d e 1 10 2 11 3 12 4 13 5 14 6 15 13 alpha beta charlie delta echo if I have 13 in cell "a35" I would like it to copy like this a b c d e f 1 10 2 11 3 12 4 13 alpha beta charlie delta echo 5 14 6 15 Hope anyone can help Thanks Browie |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with lookup code
If the list of lookup values is sorted, you can use VLOOKUP. Just use a
slightly different value in each column, e.g. for column B (assuming row 2, and using LookupTable to stand for your table of lookup values): =VLOOKUP($A2,LookupTable,2,0) For column C: =VLOOKUP($A2,LookupTable,3,0) and so on... If not sorted you can use MATCH and OFFSET in the form =OFFSET(LookupTable,MATCH($A1,LookupTableColumnA,0 )-1,1,1,1) apply this similarly in each column changing only the 3rd parameter from the end, which tells how many columns over to read the data from. "browie" wrote: Which lookup code do I use for the following On a worksheet I have a row starting with a particular number, what I need to do is for excel to look for the exact match to the number in the range "a10:a20", When it finds the match in need the code to copy the entire row to that number in the range? some thing like this a b c d e 1 10 2 11 3 12 4 13 5 14 6 15 13 alpha beta charlie delta echo if I have 13 in cell "a35" I would like it to copy like this a b c d e f 1 10 2 11 3 12 4 13 alpha beta charlie delta echo 5 14 6 15 Hope anyone can help Thanks Browie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Repost of VBA Code/Lookup question | Excel Worksheet Functions | |||
Post code lookup | Excel Worksheet Functions | |||
Zip Code Lookup Add-in | Excel Discussion (Misc queries) | |||
Code Lookup for Number | Excel Programming | |||
code for lookup,& triggers. | Excel Programming |