SOLVED
Lookup the will return multiple values
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
cablejarrett
6 - Meteoroid
‎04-08-2022
07:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Good Morning,
I have a issue where I need to look up one value and return all that match - in the example below I have 1 spreadsheets with customer data (blue) one with Price data (green) and need to return the example in (yellow).
Solved! Go to Solution.
Labels:
- Labels:
- Transformation
4 REPLIES 4
binuacs
21 - Polaris
‎04-08-2022
07:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@cablejarrett Have you tried using the join tool by joining the price list name in both the table?
‎04-08-2022
07:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
yes. but it just joins those lines. I need to to return allll the matching product values.
binuacs
21 - Polaris
‎04-08-2022
08:06 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
urbot
7 - Meteor
‎04-19-2022
12:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
how to have match values in one single cell instead of multiple row ex: if Red matches returns with baseball, baseball in column and then 456,76452 in another cell columns
