Adding Additional Logic to Existing Formula

[meppwc]

The formula below works correctly and yields to ="283879B5EA41" as the result
=IFERROR(XLOOKUP(A2,'MAC TABLE'!G:G,'MAC TABLE'!A:A),"")

I would like to add the following logic to this formula to yield to the result of 283879b5EA41 (removes the leading =" and trailing ")
MID(A2,3,LEN(A2)-3)

I am having difficulty incorporating the additional trim logic to the existing formula

 

[Fluff]

How about

=substitute(XLOOKUP(A2,'MAC TABLE'!G:G,'MAC TABLE'!A:A,""),"""","")

 

[meppwc]

Fluff
The leading = is still there using the formula that you provided.

 

[Fluff]

Didn't realize that was part of the result, try

=mid(substitute(XLOOKUP(A2,'MAC TABLE'!G:G,'MAC TABLE'!A:A,""),"""",""),2,100)

 

[meppwc]

That did it, thanks so much

 

[Fluff]

You're welcome & thanks for the feedback.