Forum Discussion
Image Function adding Implicit intersection At operator Image Function not working
Jeff_Deutch300 SOLVED - formula should be #=_xlfn.image(x,x,x,x,x) - this works for the Caxlsx XML
Appreciate everyone's support in helping resolve this issue.
From Microsoft Support -Test Summary: Test File https://urldefense.com/v3/__https:/salsify-dandelion.s3-external-1.amazonaws.com/1/6462/user_data_export/1/2023/04/24/19*3A08*3A58-10a33c9c/export.xlsx?response-content-disposition=attachment*3B*20filename*3D*22KHC-*202023*20US*20Retail*20Digital*20Catalog*20Product*20Feed_2023_04_24_19_08_58_UTC.xlsx*22&response-content-type=application*2Fvnd.openxmlformats-officedocument.spreadsheetml.sheet&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIARRX37GWVL5YUBHGV*2F20230424*2Fus-east-1*2Fs3*2Faws4_request&X-Amz-Date=20230424T190858Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=ea2b3974870e0e990178369cdd6f05da7480b52116cc9e07fe5f05c363418c5b__;JSUlJSUlJSUlJSUlJSUlJSUlJQ!!JtwtF54jn92Iq-I!aCVhjnBQZNjS82lkmMca6Qnv_MxsKLH10bqpZJmih2oGWUXvo8a_KEg45LLkVl_iftNuuP8PfxijSlJM3qQxTp6BzJSVJQ4D$
Running 365 Version 2303 Build 16227.20258 Current Channel / Windows
Opening the file you shared here is what I get (IMAGE function is avail. here no problem):
From there, if I select i.e. H2 and press Enter in the formula bar, I get:
Choosing Yes I get the expected Image :))
I suppose (???) this +/- reflects the issue you raised... Assuming this does, would you mind revising your formula in column H
From:
=IMAGE(AE2:AE2,A2,3,100,100)To (this fixed the issue here):
=IMAGE(AE2,A2,3,100,100)and let us know how it goes
IMHO, it shall work in any case if only the file is opened in proper Excel version. Using of implicit intersection operand shall not cause #NAME? error.
Agree, this should work in any case (but obviously this doesn't...)
I didn't want to confuse Jeff_Deutch300 with the following that also addresses the issue here (but raises question):
I'm not sure if + changes something for that function. And @IMAGE(AE2:AE2,.. shall work the same way as IMAGE(@AE2:AE2,...
Agree, this should work but for some reason(s) the theory doesn't seem to apply here and for Jeff_Deutch300
The IMAGE function is currently available in 365, Web, IOS and Android only & nothing - in the formula exposed by Jeff - requires the intersection operator. If it was me I would look at elimating the intersection operator and the following seems to do it:
=IMAGE(AE2,A2,3,100,100)(my view only and not my call)