CODEWITHSUNDEEP
google-sheets
Kelvs
Kelvs

Reputation: 107

Google Sheets one criteria with different and multiple results

{=IFERROR(INDEX(Table1[REPAIR & MAINTENANCE REQUESTED BUDGET],SMALL(IF(Table1[MAKE/MODEL & YEAR]=$J$10,ROW(Table1[REPAIR & MAINTENANCE REQUESTED BUDGET])-ROW('R-M Tracker'!E$2)+1),ROWS('R-M Tracker'!E$2:E5))),"")}

The above code is what I use in MS Excel, here is a sample sheet. What it does is it searches another sheet for all the records with the given criteria (value of J10). It then shows all the results in the summary report.

I've tried to replicate this on Google Sheets and use this code,

=ARRAYFORMULA(IFERROR(VLOOKUP(G5,'Comprehensive Insurance Renewal Record'!B2:C,2,false)))

Although it gives me a result, it only retrieves one and not every record that matches. I know I should add more to my code but I just don't have any idea what to add to achieve the result I want which is, it should display all matching records on their individual cells for the given criteria. Here is the sample of the sheet I'm currently working on. The given code above is written on "Vehicle Report" Sheet cell B14:B50.

Hope someone can help.

Upvotes: 0

Views: 44

Answers (1)

Kelvs
Kelvs

Reputation: 107

I've figured it out. For those who are interested, here is the correct code I used.

=QUERY('Comprehensive Insurance Renewal Record'!B2:C28, "select C where B contains '"&$G5&"'")

Upvotes: 1

Related Questions