mcdonnolda
New Member
- Joined
- Apr 22, 2011
- Messages
- 7
I have been scouring your site looking for a solution, and while I have picked up all kinds of helpful information to use, I didn't see anyone else with the challenge I have.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
></o
>
<o
></o
>
I have a single spreadsheet with multiple tabs. The main tab is my customer master database, the items tab contains one column of items that I want to track, and an orders tab that holds calendar month purchase details for all customers. Customers usually have more than one purchase per month, so we have a one to many when we look at customer # to Items purchased.<o
></o
>
<o
></o
>
What I want to do is populate an item column on the master customer database with the first matched item in the items tab.<o
></o
>
<o
></o
>
To accomplish this, I need to match the customer number (cell on my master tab) to a row in my orders tab. If a match exists, I need to then match the order item with the list of items in my item tab. If the customer # and item number are matched, I need the matched item number to be populated in the main customer database tab.<o
></o
>
<o
></o
>
I have looked at Dget and concatenating the customer number, a dash, and the item number and then doing a vlookup, but I didn't find a string command to change the numbers into characters so I could do a cat.<o
></o
>
<o
></o
>
I bow to your wisdom, <o
></o
>
Thanks<o
></o
>
Al<o
></o
>




<o


I have a single spreadsheet with multiple tabs. The main tab is my customer master database, the items tab contains one column of items that I want to track, and an orders tab that holds calendar month purchase details for all customers. Customers usually have more than one purchase per month, so we have a one to many when we look at customer # to Items purchased.<o


<o


What I want to do is populate an item column on the master customer database with the first matched item in the items tab.<o


<o


To accomplish this, I need to match the customer number (cell on my master tab) to a row in my orders tab. If a match exists, I need to then match the order item with the list of items in my item tab. If the customer # and item number are matched, I need the matched item number to be populated in the main customer database tab.<o


<o


I have looked at Dget and concatenating the customer number, a dash, and the item number and then doing a vlookup, but I didn't find a string command to change the numbers into characters so I could do a cat.<o


<o


I bow to your wisdom, <o


Thanks<o


Al<o

