| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
match data
Hi Le,
I guess it would have been better to have swapped the 5th and 6th column positions so that test1 is to the left of test 2 for both name lists. Then column 3's formula is: =VLOOKUP(A2,$D$2:$F$6,3,FALSE) filled down 3 rows and column 5's formula is: =VLOOKUP(D2,$A$2:$B$4,2,FALSE) filled down 5 rows I hope you find this useful Ken Johnson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Line Graph Data Recognition | Charts and Charting in Excel | |||
| The match and lookup functions can find literal data but not the same data referenced from a cell | Excel Discussion (Misc queries) | |||
| Shuffling Data To Make Lists Match | Excel Worksheet Functions | |||
Threaded Mode
