Trying to return results within a vLookup

[Gatsby]

Hello MrExcel,

First time poster here.

I am trying to have my vLookup return specific information rather the whole vLookup which is close to 400 characters.

Using this function, =(MID(B2,FIND("displayName",B2)+12,FIND("name",B2)-find("displayName",B2)-14)), I am able to narrow down the scope of the information I am looking for, but I cannot figure out how to add that to my vLookup.

My vLookup is pretty standard, something like this =iferror(vlookup(A2,TestLookup!A2:L1000,10,0),"") and it returns something like

{emailAddress=xxxxxxxxxxxxxxxx, avatarUrls=xxxxxxxxxxxxxxxxxxxxxxxxxxxx, 24x24=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx, 16x16=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx, 32x32=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx}, displayName=xxxxxxxxxxxxxxxxx, name=xxxxxxxxxxxxxxxxxxx, self=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx username=xxxxxxxxxxxxxxxxxxxxx, active=true, timeZone=America/Los_Angeles, key=xxxxxxxxxxxxxxxxxxxxxxxxx}

I'm not even sure if this is possible or if mid is even the best way to go about this? Any ideas?

Thanks in advance.

 

[AlanY]

how about use your =(MID(B2,FIND("displayName",B2)+12,FIND("name",B2)-find("displayName",B2)-14)) function to produce a helper column and point the vlookup() to it instead