how do you match data and paste result in a perticular cell?

K

KTN

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.
 
G

Glenn

KTN said:
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
 
M

muddan madhu

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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top