| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do you match data and paste result in a perticular cell?
Here is my problem. I have two sheets one is a policy list and the other is
a dealer list. I want to match a dealer number out of the policy list and match that number with the number on the dealer list and return the dealer name in a seperate cell. Like this... Policy List A 1 2008 11 05 0000788027 3008995 NEWBUS 146869450.pdf 2 2008 11 05 0000788027 3008999 NEWBUS 146829784.pdf Dealer List A B 1 0000788027 ABC Company USA 2 0000788038 Excel Company When the match and return are completed, I want my Policy list to look like this. Policy List A B 1 2008 11 05 0000788027 3008995 NEWBUS 146869450.pdf ABC Company USA 2 2008 11 05 0000788038 3008999 NEWBUS 146829784.pdf Excel Company Please help. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula result does not match displayed result | Excel Worksheet Functions | |||
| How do i set up blink a perticular cell? | Excel Discussion (Misc queries) | |||
| how to allow other users to make changes for some perticular cells | Setting up and Configuration of Excel | |||
| Find, Match data and paste data between two workbooks | Excel Discussion (Misc queries) | |||
| Match result is sometimes #N/A | Excel Discussion (Misc queries) | |||
Threaded Mode
