# Get Data from other speardsheet

#### antis

##### New Member
Hi guys,

How do you get data from other spread sheet?
What is the function?

For example,
on my 1st Spreadsheet (call it A.xls)
I have value in say column A will have code number and the second row will have some number. I will looks like this:

Code
1111 1112
Qty Qty
1.1 (Formula) (Formula)
1.2

Then in ther spreadsheet (B.xls) will have qty in column A, code in column B and Number in column C. It looks like:

Qty Code Number
1 1.1 1111
1 1.1 1111
1 1.2 1111
2 1.2 1112
1 1.2 1112

Then I want to get the formula in A.xls to fill the cell so that

1.1 & 1111 will have Qty of 2,
1.1 & 1112 will gave Qty of 1 and so on.

Can anyone help me pls. What should I do?

Thank you so much for any help.

### Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
does anyone can help me please?
how to lookup data from other excel spreadsheet?

Well you can use a normal formula and use the other workbook as a refercnce or just = and the other sheet referance

Hope this helps

Are you talking workbooks or worksheets?

The latter is Sheets("SheetName").Property

You set a range to that Sheets Data.

So that would be

Set anotherSheet = Sheets("SheetName).Range.("wherever) or ~~~.Range.("wherever").Currentregion

The former....

Well, I'd have to look that up.

I am talking about the different worksheet. NOT workbook.
As my example before. file A.xls will look data from file b.xls
The location of those 2 files will be the same.

So Pegasus, should I use your formula?

Doest work. I dont understand what r u talking about.
Sorry.
Can u give me some example formula using my example above please.

Thank you

Working from different files, well, that sounds like different workbooks to me.

But regardless, it's beyond my experience.

I'm sorry, I can't help.

Yes different files but still excel file.

Hopefully there is someone in this forum can help me.

cheers.

Replies
9
Views
160
Replies
10
Views
166
Replies
3
Views
169
Replies
8
Views
314
Replies
0
Views
179

1,196,308
Messages
6,014,580
Members
441,828
Latest member
cofracr

### 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