Destination cells D3:D300 in a spread sheet named April residing in the same folder as the source spread sheet named Source. I am trying to pull data from a tab named Analytics
When any value column A3:A300 in destination sheet = the value in B3:B300 of the Source sheet then present the value in G3:G300 in D3:D300 in the destination cell.
Something similar to this:
=IFERROR(VLOOKUP($A3,[Source.xlsx]Analytics!$B$3:$B$300,COLUMN()-3,FALSE),"")
This isn’t working. It displays the value in B3 from the source file. If I change the -3 to anything else, higher or lower, it leaves the cell blank. I’m missing something obvious. Thought?
Thanks in advance.
When any value column A3:A300 in destination sheet = the value in B3:B300 of the Source sheet then present the value in G3:G300 in D3:D300 in the destination cell.
Something similar to this:
=IFERROR(VLOOKUP($A3,[Source.xlsx]Analytics!$B$3:$B$300,COLUMN()-3,FALSE),"")
This isn’t working. It displays the value in B3 from the source file. If I change the -3 to anything else, higher or lower, it leaves the cell blank. I’m missing something obvious. Thought?
Thanks in advance.