Formula off for pulling data from one spreadsheet to another

[RodneyW]

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.

 

[Joe4]

The range in your source file needs to include the column that you are bringing back.
So I think you need to change your ending colums:
[Source.xlsx]Analytics!$B$3:$B$300

What exacrly are you trying to do here?
COLUMN()-3
Note that will take the column number of the column that you have placed this formula in, and subtract three from it.
What column are you putting these formulas in?

 

[Fluff]

How about
=IFERROR(VLOOKUP($A3,[Source.xlsx]Analytics!$B$3:$G$300,6,FALSE),"")

 

[RodneyW]

Formulas are going in column D, trying to pull from Column G Changing the -3 to a +3 doesn't solve it

 

[Mentor82]

Hi,
How about changing the range $B$3:$B$300 to $B$3:$G$300 and next Column()-3 replace with 3 and płace the formula in column D and fill in down the range.

 

[Fluff]

Did you try the formula in post#3?

 

[RodneyW]

Yahtzee! thanks guys

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Mentor82]

Hi, did mistake in my formula placing 3 instead of 6. Anyway, I’m glad we could help. Thanks for reply.