hi every one,
i have this in google sheet named "123", sheet1 (please dont delete this thread if google sheet is not supported here):
i have this in google sheet named "456", sheet2 (2 separate google sheets files):
and i want this:
- if A2&B2 in "456", sheet2 matches any value in A&B in "123", sheet 1 ---> then show the value of E in "123", sheet1 to cell F in "456", sheet2
i tried this but somehow it didnt work for me:
=VLOOKUP(A1&B2,CHOOSE({1,2},IMPORTRANGE("google sheet named "123" url","sheet1!A1:A99999")&IMPORTRANGE("google sheet named "123" url","sheet1!B1:B99999"),IMPORTRANGE("google sheet named "123" url","sheet1!E1:E99999")),2,FALSE)
*in case you dont know, heres the importrange formula: https://support.google.com/docs/answer/3093340?hl=en
please help.
i have this in google sheet named "123", sheet1 (please dont delete this thread if google sheet is not supported here):

i have this in google sheet named "456", sheet2 (2 separate google sheets files):

and i want this:
- if A2&B2 in "456", sheet2 matches any value in A&B in "123", sheet 1 ---> then show the value of E in "123", sheet1 to cell F in "456", sheet2
i tried this but somehow it didnt work for me:
=VLOOKUP(A1&B2,CHOOSE({1,2},IMPORTRANGE("google sheet named "123" url","sheet1!A1:A99999")&IMPORTRANGE("google sheet named "123" url","sheet1!B1:B99999"),IMPORTRANGE("google sheet named "123" url","sheet1!E1:E99999")),2,FALSE)
*in case you dont know, heres the importrange formula: https://support.google.com/docs/answer/3093340?hl=en
please help.
Last edited: