Hello
I trying to apply a VLOOKUP formula between to spreadsheets that are on 2 different sharepoint sites on the same tenant.
In idea is that the formula looks up the table range VMLYR_RF_TABLE in the tab VMLYR_RF of the xlsx file.
Sadly, it is not working and excel does not indicate why.
Any thoughts on this are most welcome
Welcome to the forum.
Please change your forum profile to the version (365?) of Excel that you are running.
What is the formula that you have tried? What is the error message? Are both workbooks open?
More detail, please.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hello
I am struggling to copy the formula as I get an error
"You are not allowed to post any kinds of links, images or videos until you post a few times."
My excel build is : 16.0.15009.31877
Thank you
You can not post links, etc, yet. But you can post your excel file. Read the yellow banner (top) for instructions.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
This is Excel 2016, which is what you need to show in your profile, please.16.0.15009.31877
Thanks. I did not think about that.
The workbook contains no formula - just a hard copied #VALUE error message.
I suggest you copy the formula to your next post - split it into THREE sections so that the forum software allows you to post.
It's just not your day!! All we can see in that file is #VALUE. We can not see the formula that is causing it.
Try pasting the formula into a post in this thread. Are there any < symbols in it?? If so paste and add a space after them.
@Glenn - I think it will be the Sharepoint link in the formula that the forum software won't like. This is why I've suggested the OP split it into three sections.
Please Login or Register to view this content.
It seems that the site is looking for the colon and forward strokes so I have covered them with ***
No - please don't do it this way!!!
Break the whole thing into sectioms, but don't CHANGE anything.
Try again, please!
In short, I put a barcode into cell K3 and the formula consults around excel file on another sharepoint site to pull up the equipment details.
I am adapting a working formula when I could host the 2 files locally. I cannot find anything on the web about VLOOKUP over different places.
Please Login or Register to view this content.
Please Login or Register to view this content.
Please Login or Register to view this content.
So is the error a #VALUE error or a #REF error? The former suggests that the VLOOKUP is finding the relevant data, but there is a mismatch (it's finding a number instead of text, ore vice versa). If the latter, then it may need both workbooks open.
I assume it's a #VALUE error, so you need to check that the lookup value and the values in the lookup range are of the same type.
With nothing further to go on, this is the best I can offer.
EDIT: Just noticed that your VLOOKUP foormula is missing the final argument (0 for an EXACT match, 1 for an approximate match).
=VLOOKUP(file_path!($k3,****_rf_table,5,missing_argument)
What EXACTLY is in K3?
What EXACTLY is in the lookup range? Does the lookup range have five columns? Is the lookup value in the first of those columns?
Last edited by AliGW; 02-18-2022 at 05:17 AM. Reason: Typo fixed.
K3 in the test file has a value of Y04804 which is a computer barcode number
the range is predefined in the file that is being looked up and hold about 10 columns and 200 rows. My goal is for the VLOOKUP to scan the range for Y04804 and pull up the info in the column 5 of the same row .
The online excel I have to use does not show any error message apart from being flagged in red . I will investigate what missing_argument maybe needed.
Thank you
I'm hoping Glenn has some better ideas. I think I've exhausted what I can do to help at this point.
I presume that excel files hosted on sharepoint are constantly "open" so therefore constantly consultable. But it is a presumption because I cannot find any info on the web about this.
Thank you for all your help.
I'm not so sure that your presumption is correct, but I have no evidence to offer - sorry. When I was working with Sharepoint files, I pulled data from one to another using PowerQuery, and that definitely does NOT require source files to be open.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks