| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match with copy
I have 2 sheets. I need to compare F92 of Sheet-1 with Sheet-2 range from
F21:F9500. If there is a match then I need to see corresponding value in cell I of sheet-2. If that value is R, then on Sheet-1, next to F92 I need to insert value of cell J from Sheet-2 into G92 of Sheet-1. I need to check Sheet-1 F92 thru F2000. As a result, I will see some cells with values in column J of Sheet-1. How can I do this? Sheet-1: Col-F Col-G 1234567890 1234576889 1234864534 1234895498 1234922374 1234944784 Sheet-2: Col-F Col-I Col-J 1234567890 C 1234573245 1234576889 R FedEx 293833849505 1234895498 1234921132 X 1234922374 R UPS 1Z585960604968 Result Should be: Sheet-1: Col-F Col-G 1234567890 1234576889 FedEx 293833849505 1234864534 1234895498 1234922374 UPS 1Z585960604968 1234944784 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match and copy | Excel Worksheet Functions | |||
| Compare Col A and Col M, if Match, Copy Col N to Col E | Excel Worksheet Functions | |||
| Compare col and match then copy and paste | Excel Discussion (Misc queries) | |||
| Match and Copy | Excel Worksheet Functions | |||
| Copy to next empty row, if not a match | Excel Discussion (Misc queries) | |||
Threaded Mode
