Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Urgent help(Find, match and copy)
HI
everybody In sheet1 I have a data like this A B C D E F G H I Sub Me M1 M2 M3 M4 M5 M6 M7 31 40 12 23 45 34 23 12 45 32 40 6 7 9 5 6 7 4 31 34 2 3 4 3 6 7 3 32 34 1 2 5 7 6 8 9 - 21 2 4 5 6 7 5 2 Sheet2 looks like this A B C D E F G H .... Sub Me M1 M2 M3 M4 M5 M6... 31 40 - 21 32 40 31 34 32 34 I need to match ColA and Col B in sheet1 and sheet2. When the the values of ColA and ColB of sheet1 matches with the value of colA and ColB of sheet2 then I need to retrieve the value of that row from sheet1 and copy it in sheet2. Any help would be highly appreciated Thanx in advance -- Kittie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT - MATCH CALL DETAILS 2 FIND RELEVANT EXTN - URGENT PLS! | Excel Discussion (Misc queries) | |||
Urgent:Find match between two worksheets and copy to another sheet | Excel Worksheet Functions | |||
find closest match and copy to sheet1 | Excel Discussion (Misc queries) | |||
Find closest match and copy | Excel Discussion (Misc queries) | |||
Find and Match in one worksheet and get data (Very Urgent) | Excel Programming |