# get data from a different workbook based on cell data

#### ensee

##### New Member
I have two workbooks.

Workbook 1 is called Summary and has a single sheet call Additional_Info

Workbook 2 is called Income and contains twelve sheets Jan, Feb, March etc....
on each sheet I have named range JanWS, FebWS, MarWS etc....

When I type the the month (lets say June) into cell B6 in Summary.xlsx sheet Additional_Info, I want to get the data from Income.xlsx sheet June cell Q17 and paste the data into Summary.xlsx sheet Additional_Info cell G2

Again when I type the the month (lets say Feb) into cell B6 in Summary.xlsx sheet Additional_Info, I want to get the data from Income.xlsx sheet Feb cell Q17 and paste the data into Summary.xlsx sheet Additional_Info cell G2

Any help would be appreciated

### Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
Try this formula in cell G2:

=INDIRECT("'[Income]"&B6&"'!Q17")

MisterCrash Thanks.... getting there

It returns the value correctly

When I type the the month (lets say June) into cell B6 in Summary.xlsx sheet Additional_Info, I then want to look up cell B2 in Summary.xlsx sheet Additional_Info, go to the Income.xlsx sheet June, look up the value from B2 that we got from Summary.xlsx sheet Additional_Info, get the info from cell Q2 of the Income.xlsx sheet and paste the data into Summary.xlsx sheet Additional_Info cell G2

MisterCrash

I have solved this with your help, very much appreciated ! Awesome !!!

=VLOOKUP(B19,INDIRECT("'[Income]"&\$B\$6&"'!\$A\$2:\$Q\$2001"),"17")

Replies
1
Views
190
Replies
6
Views
135
Replies
1
Views
271
Replies
1
Views
99
Replies
2
Views
139

1,214,891
Messages
6,122,101
Members
449,066
Latest member
Andyg666

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back