'Get data from list with multiple rows with unique ID on Excel/Google Sheets
I'm currently using google sheets for my project. I have an excel workbook containing multiple sheets. The task here is to create a summarized format of all sheets for a certain time period.
The output should look like this:
My current problem is getting data from a sheet with multiple rows that have the same identifier. This is sheet number 1, I already got all the data that I need from here:
But in sheet 2, I need to be able to extract the status from this sheet for the summary:
I tried to use an IF ELSE statement with a VLOOKUP function but to no avail.
(NOTE: I cannot share my sheet due to sensitive information. Refer to sample For context, the sheets come from a 10 year old website.)
Solution 1:[1]
try:
=INDEX(IFNA(VLOOKUP(A16:A18&B16:B18&C16:C18, {A7:A12&C7:C12&D7:D12, E7:E12}, 2, 0)))
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | player0 |