CODEWITHSUNDEEP
excelgoogle-sheetsexcel-formulagoogle-sheets-formula
danedelions_swift
danedelions_swift

Reputation: 125

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:

desired output

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:

sheet 1

But in sheet 2, I need to be able to extract the status from this sheet for the summary:

enter image description here

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.)

Upvotes: 1

Views: 505

Answers (1)

player0
player0

Reputation: 1

try:

=INDEX(IFNA(VLOOKUP(A16:A18&B16:B18&C16:C18, {A7:A12&C7:C12&D7:D12, E7:E12}, 2, 0)))

enter image description here

Upvotes: 1

Related Questions