Excel VLOOKUP - Searching Data from another workbook
- Thread starter oberhrc
- Start date
dgavilanes
Member
It will be nice having a sample of data, however I used my own data and I came up with this and mine works!
=VLOOKUP(I3,Ipad_SY2012_MT.csv!$B$1:$C$14,1,FALSE) once you get the results drag it down
please compared to your vlookup below
=VLOOKUP(F2,'[File Name.xlsx]Tab Name!$A$2:$F$6146,6,FALSE).
Hope it helps
Dennis
=VLOOKUP(I3,Ipad_SY2012_MT.csv!$B$1:$C$14,1,FALSE) once you get the results drag it down
please compared to your vlookup below
=VLOOKUP(F2,'[File Name.xlsx]Tab Name!$A$2:$F$6146,6,FALSE).
Hope it helps
Dennis
SirJB7
Excel Rōnin
Hi, oberhrc!
First of all welcome to Chandoo's website Excel forums. Thank you for your joining us and glad to have you here.
As a starting point I'd recommend you to read the three first green sticky topics at this forums main page. There you'll find general guidelines about how this site and community operates (introducing yourself, posting files, netiquette rules, and so on).
Among them you're prompted to perform searches within this site before posting, because maybe your question had been answered yet.
Feel free to play with different keywords so as to be led thru a wide variety of articles and posts, and if you don't find anything that solves your problem or guides you towards a solution, you'll always be welcome back here. Tell us what you've done, consider uploading a sample file as recommended, and somebody surely will read your post and help you.
And about your question...
Are you sure that the value searched (F2 cell value) exists in column 6 of the sheet Tab_Name in workbook File_Name.xlsx? Because VLOOKUP used with last parameter FALSE displays a #¡N/A# when not found.
Regards!
First of all welcome to Chandoo's website Excel forums. Thank you for your joining us and glad to have you here.
As a starting point I'd recommend you to read the three first green sticky topics at this forums main page. There you'll find general guidelines about how this site and community operates (introducing yourself, posting files, netiquette rules, and so on).
Among them you're prompted to perform searches within this site before posting, because maybe your question had been answered yet.
Feel free to play with different keywords so as to be led thru a wide variety of articles and posts, and if you don't find anything that solves your problem or guides you towards a solution, you'll always be welcome back here. Tell us what you've done, consider uploading a sample file as recommended, and somebody surely will read your post and help you.
And about your question...
Are you sure that the value searched (F2 cell value) exists in column 6 of the sheet Tab_Name in workbook File_Name.xlsx? Because VLOOKUP used with last parameter FALSE displays a #¡N/A# when not found.
Regards!
NARAYANK991
Excel Ninja
Hi ,
The problem is your parameters are wrong :
=VLOOKUP(lookup_value,lookup_range,return_column,TRUE/FALSE)
Here , your lookup value is in cell F2 ; the lookup_range is A2:F6146 ; VLOOKUP always looks in the first column of the lookup_range for the lookup_value. Here , I think the value in F2 is not to be found in column A of your lookup_range.
You can change your lookup_range from A2:F6146 to F2:F6146 , but then , you should also change the return_column parameter from 6 to 1.
Narayan
The problem is your parameters are wrong :
=VLOOKUP(lookup_value,lookup_range,return_column,TRUE/FALSE)
Here , your lookup value is in cell F2 ; the lookup_range is A2:F6146 ; VLOOKUP always looks in the first column of the lookup_range for the lookup_value. Here , I think the value in F2 is not to be found in column A of your lookup_range.
You can change your lookup_range from A2:F6146 to F2:F6146 , but then , you should also change the return_column parameter from 6 to 1.
Narayan
Hi Everyone,
Thank you for all your responses. I know my question is a bit vague but here is what I'm running into.
I have two workbooks one that is called "Lookup Data Example" and another called "Lookup Data Groups" I want to be able to use the vlookup formula in the Lookup Data Example to search for the owner name based on the directory name from the other workbook.
In column G2 I enter in =VLOOKUP(F2,[LookupDataGroups.xlsx]Lookup_Data_FileServer'!$A$2:$F$7,6,FALSE)to search by the directory name. From the other workbook Column F2 I'm searching for the owner of the directory and I get an #NA error.
Let me know if I'm entering in the formula correctly
Again thanks for all your help!
Thank you for all your responses. I know my question is a bit vague but here is what I'm running into.
I have two workbooks one that is called "Lookup Data Example" and another called "Lookup Data Groups" I want to be able to use the vlookup formula in the Lookup Data Example to search for the owner name based on the directory name from the other workbook.
In column G2 I enter in =VLOOKUP(F2,[LookupDataGroups.xlsx]Lookup_Data_FileServer'!$A$2:$F$7,6,FALSE)to search by the directory name. From the other workbook Column F2 I'm searching for the owner of the directory and I get an #NA error.
Let me know if I'm entering in the formula correctly
Again thanks for all your help!
SirJB7
Excel Rōnin
Hi, oberhrc!
As I tried to mean in my first answer and as NARAYANK991 catched up:
a) the syntax is correct (value, range, column, T/F)
b) the formula will display #N/A if F2 value doesn't exist in cells A2:A7 of sheet Lookup_Data_FileServer in workbook LookupDataGroups.xlsx, otherwise it will display the value of column F corresponding to the row where the first occurrence of F2 happens
If checking this you still have issues, consider uploading a sample file as indicated in second green sticky post.
Regards!
As I tried to mean in my first answer and as NARAYANK991 catched up:
a) the syntax is correct (value, range, column, T/F)
b) the formula will display #N/A if F2 value doesn't exist in cells A2:A7 of sheet Lookup_Data_FileServer in workbook LookupDataGroups.xlsx, otherwise it will display the value of column F corresponding to the row where the first occurrence of F2 happens
If checking this you still have issues, consider uploading a sample file as indicated in second green sticky post.
Regards!
NARAYANK991
Excel Ninja
Hi ,
I'll try to explain :
1. You have two workbooks , one named Lookup Data Example.xlsx , and the other named Lookup Data Groups.xlsx
2. You are using the VLOOKUP formula in the first workbook , the one named Lookup Data Example.xlsx
3. The exact formula would be :
=VLOOKUP(F2,'[Lookup Data Groups.xlsx]Lookup_Data_FileServer'!$A$2:$F$7,6,FALSE)
Copy this to your file and see if you still get the error. If you do , then it is clear that the data in cell F2 of your workbook named Lookup Data Example.xlsx does not exist in column A of your workbook named Lookup Data Groups.xlsx
If you do not want to find the lookup value in column A , but in column F , then change the range from $A$2:$F$7 to $F$2:$F$7 , and change the third parameter from 6 to 1.
I am assuming that you have copied and pasted the names of your workbooks and worksheet exactly.
Narayan
I'll try to explain :
1. You have two workbooks , one named Lookup Data Example.xlsx , and the other named Lookup Data Groups.xlsx
2. You are using the VLOOKUP formula in the first workbook , the one named Lookup Data Example.xlsx
3. The exact formula would be :
=VLOOKUP(F2,'[Lookup Data Groups.xlsx]Lookup_Data_FileServer'!$A$2:$F$7,6,FALSE)
Copy this to your file and see if you still get the error. If you do , then it is clear that the data in cell F2 of your workbook named Lookup Data Example.xlsx does not exist in column A of your workbook named Lookup Data Groups.xlsx
If you do not want to find the lookup value in column A , but in column F , then change the range from $A$2:$F$7 to $F$2:$F$7 , and change the third parameter from 6 to 1.
I am assuming that you have copied and pasted the names of your workbooks and worksheet exactly.
Narayan
SirJB7
Excel Rōnin
@sharath
Hi!
Would you please start a new topic instead of writing on another user's one? It might be seen as hijacking.
Perhaps you'd want to read the three green sticky posts at this forums main page so as to know the guidelines that will lead to know how this community operates (introducing yourself, posting files, netiquette rules, and so on).
Regards!
Hi!
Would you please start a new topic instead of writing on another user's one? It might be seen as hijacking.
Perhaps you'd want to read the three green sticky posts at this forums main page so as to know the guidelines that will lead to know how this community operates (introducing yourself, posting files, netiquette rules, and so on).
Regards!