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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do you match data and paste result in a perticular cell?
KTN wrote:
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. Look at this: http://contextures.com/xlFunctions02.html |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do you match data and paste result in a perticular cell?
try this
in price list sheet - cell B1 put this formula =INDEX('Dealer List'!$B$1:$B$10,MATCH("*"&'Dealer List'!A1&"*",'Policy List'!$A$1:$A$10,0)) On Nov 6, 10:31*pm, KTN wrote: 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do you match data and paste result in a perticular cell?
For some reason this is not working. Am I missing something?
"muddan madhu" wrote: try this in price list sheet - cell B1 put this formula =INDEX('Dealer List'!$B$1:$B$10,MATCH("*"&'Dealer List'!A1&"*",'Policy List'!$A$1:$A$10,0)) On Nov 6, 10:31 pm, KTN wrote: 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. |
Reply |
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) |