Hi all, I have a GSheet with two tabs 'Sheet 1' and 'Raw Data'. I need to Look up an 'Opportunity Number' from Sheet One (column A) and find this in 'Raw Data Tab' (Column A) and Return Multiple 'Partners' from 'Raw Data tab' (Column B). Please see attached Mini-Sheet, I need the results in one Row on Tab Sheet 1 (B:F) with 'No Partner' where there is no data, OR, Can have the Results concatenated into one cell (EG B10:B12) with punctuation separating results (does not matter what punctuation). 'Sheet 1' will be used for many other Data sets and formulas, it will be a sheet used by many Users so need to ensure I can present this data in a single row. Not sure I can do this without using a Table or FILTER function, so rather than muck around for ages I thought I'd ask the experts! NOTE: Apologies I cannot download XL2BB currently due to restrctions from my Company, so have added images instead.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
GSheet issue, need to lookup a value from 1 tab to another tab, and return multiple values from one column
Fluff
MrExcel MVP, Moderator
- Joined
- Jun 12, 2014
- Messages
- 92,724
- Office Version
- 365
- Platform
- Windows
In future please post questions about Gsheets in the General Discussion & Other Applications section of the board. I have moved it for you this time.
How about
How about
Excel Formula:
=TOROW(FILTER('Raw Data'!B2:B10,'Raw Data'!A2:A10=A3))
Upvote
0
Solution
Hi Fluff, many thanks, works a charm! Apologies for the error in posting for GSheet, been a long time since I have been on the board so thanks for moving and will remember for next time. Thanks again
Upvote
0
Similar threads
- Solved
- Question
- Question
