Gathering information from another sheet, if information not on that sheet, gathering from another

Mallory N

I am trying to figure out a formula that will allow for me to gather information from multiple sheets (not a sum). We have multiple logs (one for each year) and i am trying to link all of this data to one sheet so it needs to look at multiple sheets for the information. I am currently only linked to one log and this is the formula that i am using:

=IFERROR(INDEX(COLLECT({Quote Log 2024 Quote Status}, {Quote Log 2024 LCI Quote #}, @cell = [Quote Number]@row), 1), "")

Is it possible to also link this to a 2023 Log and then eventually to a 2025 log?

Thank you in advance for any assistance.

Toufong Vang

Hi, @Mallory N , yes can nest multiple IFERROR() functions. In this case:

IFERROR(expression_for_2024_Log, IFERROR(expression_for_2023_Log, IFERROR(expression_for_2025_Log, "")))

Cheers!