| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
match and list
hi all
worksheet 1 range of values from a1 to a100. corrseponding names in b1 to b100 worksheet 2 values from coluimn A worksheet 1 appear but in different order in column G:need to have corresponding name from b column wksheet 1 appear in d column worksheet 2 heklp pls cheers anthony |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
match and list
in D2:
=VLOOKUP(G2,Sheet1!$A:$B,2,0) Copy down HTH "Anthony" wrote: hi all worksheet 1 range of values from a1 to a100. corrseponding names in b1 to b100 worksheet 2 values from coluimn A worksheet 1 appear but in different order in column G:need to have corresponding name from b column wksheet 1 appear in d column worksheet 2 heklp pls cheers anthony |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using the MATCH formula and list the duplicates | Excel Worksheet Functions | |||
| Using Index Match etc. for price list | Excel Worksheet Functions | |||
| match word in one column form list in another | Excel Worksheet Functions | |||
| Product list to match price list | Excel Discussion (Misc queries) | |||
| "Suggest a match" from a list or drop down. | Excel Worksheet Functions | |||
Linear Mode
