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

  • Thread starter Thread starter KTN
  • Start date Start date
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.
 
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.
Click to expand...


Look at this:


http://contextures.com/xlFunctions02.html
 
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))
 
Back
Top