Comments on: Google Sheets INDIRECT Function Guide (3 Examples)

By: Ousmane SY

Ousmane SY — Sun, 05 Jun 2022 14:23:16 +0000

Thanks a lot.

By: SB

SB — Wed, 04 May 2022 17:14:56 +0000

Is it possible to use INDIRECT FUNCTION with IF. For example:-

=IF(AND(H19=8, I19=”Test”),=INDIRECT(J19))

I get an error when I put this formula. The =INDIRECT(J19) works on its own but when put with the other function, it doesnt work. I would like the google sheet to return the value in J19 id H19=8 and I19=Test.

By: prakash

prakash — Tue, 28 Sep 2021 12:16:05 +0000

In reply to Simón. yes

By: Simón

Simón — Sun, 30 May 2021 20:08:48 +0000

Isn’t it possible to use an INDIRECT reference with the FILTER function?

By: yaya

yaya — Mon, 29 Mar 2021 13:20:15 +0000

Great content thank you !!

there is a little typo I think, an extra “!” :

“in cell B2, the function was =INDIRECT(A2&!”!B2”), which refers to cell Red!B2”