Not returning on a vlookup, using
=vlookup(a2,[UrlIndexed.xlsx]ScrapeBox!$A:$B,2,false)
To me that says range a and b?
the two files are included, never had all these problems before but I am tired.
Thanks.
T
Not returning on a vlookup, using
=vlookup(a2,[UrlIndexed.xlsx]ScrapeBox!$A:$B,2,false)
To me that says range a and b?
the two files are included, never had all these problems before but I am tired.
Thanks.
T
Where is the formula?
If posting code please use code tags, see here.
=vlookup(a2,[UrlIndexed.xlsx]ScrapeBox!$A:$B,2,false)
I'm trying to return URL indexed column, yes or no.
Thanks!
Hi,
Actually your excel (backlinkanalysisM2MM) spreadsheet is opening in Compatibility Mode.
To get out of compatibility mode, you open the excel (backlinkanalysisM2MM) file, then select a "save as" with it and then select excel workbook. That will put this particular file in excel 2007 native mode.
Then you use the same vlookup formula. It will work.
=vlookup(a2,[UrlIndexed.xlsx]ScrapeBox!$A:$B,2,false)
Thanks
tjc100
As far as I can see there's nothing wrong with your formula.
Mind you I don't actually know which sheet it's meant to be on and therefore what the A2 value is.
Alternately, restrict your formula a bit
i.e.
=VLOOKUP(A2,[UrlIndexed.xlsx]ScrapeBox!$A1:$B500,2,FALSE)
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks