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