Aug 05 2024 04:30 AM - edited Aug 05 2024 04:31 AM
Can anyone show me the correct way to use the value of cell E20 in this formula? My attempt returns an error.
Many thanks.
Aug 05 2024 04:39 AM
Perhaps
=XLOOKUP(1, INDIRECT("'"&$A$1&"'!I3:I"&$E$20), INDIRECT("'"&$A$1&"'!E3:E"&$E$20), "-", 0, 1)