Hi everyone,
I would like to get some data from another excel file. But every data that i needed is located in another sheet.
I created a column that contains the correct pages. And i want to use a formula by using that column. Like;
=VLOOKUP(M28;'[Example.xlsx]The Sheet'!$F$1135:$P$1218;4;0)
I want that the sheet be like;
=VLOOKUP(M28;'[Example.xlsx]MyMainSheetC6'!$F$1135:$P$1218;4;0)
Thanks in advance
If you know INDIRECT function then try it else attach sample file...
Last edited by mangesh.mehendale; 10-12-2015 at 05:45 AM.
Don`t care, take care...
Regards,
Mangesh
I'm not sure I understand your question. If you want to reference another workbook then open the reference workbook, when you write your formula in your sheet, then click on the other workbook for your formula that refers to that book and finish the formula.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
@ moakcan...
Thanks for Reputaion points.. If it works for you then mark thread as Solved..(See at top right side "Thread Tools")
No unfortunatelyOriginally Posted by mangesh.mehendale
...
- In A.xls file, I have the B2 cell which is a list of the products.
- In the list there are 4 names. Every name is also the name of the sheets in another excel file( Lets call it B.xls - 4 different sheets)
- I want this: when the user select the product from the 4-named-list, I have to bring the price of this product from the B.xls file.
If there is not 4 different name, formula would be like;
=VLOOKUP(M28;'[Example.xlsx]The Sheet'!$F$1135:$P$1218;4;0).
But i have 4 different sheet that i have to use in B.xls file. So it have to be like
=VLOOKUP(M28;'[Example.xlsx]B2'!$F$1135:$P$1218;4;0)
Since the text in the B2 cell is the exact name of the sheet (in B.xls). There musn't be any problem. But when i try to write this. Excel gives me a warning message. So my question is how do i do that?
I couldnt do this with INDIRECT. Could you show me if it is possible?
Thank you very much
Last edited by moakcan; 10-12-2015 at 09:03 AM.
not getting actually... It would be easy to solve if you attach sample files with desired results...
I couldnt find how to attach files but i attached the pics
here they are;
Attachment 424310
Attachment 424311
As you can see the SKU names im con1 and the sheet names in con2 are the same. So i want to write a formula.
When "Nestle 100gr." selected, it will bring the price from the "Nestle 100gr." sheet(another excel file), and when "Nestle 120gr." selected, it will bring the price from the "Nestle 120gr."
Now the formula is this:
=VLOOKUP(D4;'[Cont 2.xlsx]Nestle 100gr'!$C$4:$G$4;2;0)
But it brings only the price in the "Nestle 100gr" sheet. So what about i choose the "Nestle 120gr"? It has to be dynamic and goes the other sheet. But how
Thank you again
see attached files Hope this is what you want.... Else Click on "Go Advanced" => Manage Attachments => Add File.. (to attach your files)
Formula:
Please Login or Register to view this content.
Thank you very much! It worked.see attached files Hope this is what you want.... Else Click on "Go Advanced" => Manage Attachments => Add File.. (to attach your files)
Formula:Please Login or Register to view this content.
But as far as i understood. The excel file that i referenced must be open while doing it.
I will do it that way.
Thank you again.
Please note Other excel file should be open and when you close current file and reopen it the again other file required to open to take effect...
If you don`t want to open other files again and again you should have to Paste Special after applying formula...
Please mark this thread as Solved (See at Top "Thread Tools"
Please note Other excel file should be open and when you close current file and reopen it the again other file required to open to take effect...
If you don`t want to open other files again and again you should have to Paste Special after applying formula...
Please mark this thread as Solved (See at Top "Thread Tools")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks