If Sheet1 A2, matches Sheet2 A2:A1000, then list all values from Sheet2 B2:B1000 in Sheet1 B2.
Example:
A2 B2
Work Menards, Lowes, Home Depot
If Sheet1 A2, matches Sheet2 A2:A1000, then list all values from Sheet2 B2:B1000 in Sheet1 B2.
Example:
A2 B2
Work Menards, Lowes, Home Depot
Try this in Sheet1!B2 and copy down
Formula:Please Login or Register to view this content.
Can you post a SMALL sample file and show us what result you expect?
20 rows and 2 columns worth of data is plenty.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks