Hi,
Built a spreadsheet in Google Sheets as some of the functions were just simpler but need to now bring it in to excel due to company IT guidelines.
Need to return multiple results from a lookup table. This is the formula I use in Google Sheets
=IFERROR(ArrayFormula(query('Datasheet - Contract Audit Report'!A2:D1000, "select B, C where A = '"&B1&"'"))," ")
Thanks for any help!
Bookmarks