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

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

 

[Glenn]

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

 

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

 

[KTN]

For some reason this is not working. Am I missing something?