Gsheets VLOOKUP returning multiple values
Matt
I have this sheet:
| refid | customerid | invoiceno |
|---|---|---|
| 5756588282 | 5364889 | 63849050 |
| 5756588282 | 5364889 | 62227291 |
| 5756588282 | 5364889 | 60565767 |
| 5756588303 | 5765682 | 62724304 |
| 5756588303 | 4137278 | 62721119 |
| 5756588303 | 4480623 | 62725914 |
| 5756587180 | 1737070 | 66385042 |
| 5756587180 | 1737070 | 66219284 |
| 5756587579 | 3008601 | 64004057 |
| 5756587579 | 3008601 | 62358070 |
I need to do a vlookup with the refid and move in the other sheet the customerid and invoiceno but I only get the first row. I need to go back here, highlight duplicates and for each refid copy/paste the customerid and invoiceno in the other sheet. This can be automated.
What is a formula that gives me all the customerid and invoiceno where the refid matches? I've tried with a textjoin and a query but I can't make it work.
What I need to achieve in the other sheet:
refid - customerid - invoiceno
JvdV
Something alone these lines perhaps:
Formula in G2:
={TEXTJOIN(CHAR(10),1,FILTER(B2:B;A2:A=E2)),TEXTJOIN(CHAR(10),1,FILTER(C2:C,A2:A=E2))}
This will now spill both
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: Calculate difference between min and max values in a group after a groupby
- Next: SQL Query show last value regarding the next one
Related
TOP Ranking
- 1
Loopback Error: connect ECONNREFUSED 127.0.0.1:3306 (MAMP)
- 2
Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background
- 3
pump.io port in URL
- 4
How to import an asset in swift using Bundle.main.path() in a react-native native module
- 5
Failed to listen on localhost:8000 (reason: Cannot assign requested address)
- 6
Spring Boot JPA PostgreSQL Web App - Internal Authentication Error
- 7
Emulator wrong screen resolution in Android Studio 1.3
- 8
3D Touch Peek Swipe Like Mail
- 9
Double spacing in rmarkdown pdf
- 10
Svchost high CPU from Microsoft.BingWeather app errors
- 11
How to how increase/decrease compared to adjacent cell
- 12
Using Response.Redirect with Friendly URLS in ASP.NET
- 13
java.lang.NullPointerException: Cannot read the array length because "<local3>" is null
- 14
BigQuery - concatenate ignoring NULL
- 15
How to fix "pickle_module.load(f, **pickle_load_args) _pickle.UnpicklingError: invalid load key, '<'" using YOLOv3?
- 16
ngClass error (Can't bind ngClass since it isn't a known property of div) in Angular 11.0.3
- 17
Can a 32-bit antivirus program protect you from 64-bit threats
- 18
Make a B+ Tree concurrent thread safe
- 19
Bootstrap 5 Static Modal Still Closes when I Click Outside
- 20
Vector input in shiny R and then use it
- 21
Assembly definition can't resolve namespaces from external packages
Comments