Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
e.g. function LookupExpense(LookupValue) ' get all the row numbers by looping through this until Row(n:n) returns no more values: ' RowNum =SMALL(IF('expenses'!$H:$H=LookupValue,ROW('expenses'!$H:$H)),ROW(1:1)) ' Result =INDEX('expenses'!$A$1:$N$9999,RowNum, 5) ' for each rownum LookupExpense = LookupExpense & char(10) & Result end function
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.