Index Match Help!
I'm trying to use Index Match formula instead of Vlookup due large amount of datas .
Ive heard that its faster than using Vlookup formula .
However , I encounter an error along this line .
Please Login or Register to view this content.
I dont know what went wrong with my formula
Please help
Please Login or Register to view this content.
not entirely sure what you are trying to do as formula does not make sense
you have an extra comma in the the code for the formula
then the issue isPlease Login or Register to view this content.
your formula outputs
Formula:
Please Login or Register to view this content.
which obviously does not work matching whole column C
i suggest you go and use normal formula instead of R1C1 which you seem to be having issues understanding
replace A:A and/or J:J with what you do want in your formulaPlease Login or Register to view this content.
Last edited by humdingaling; 07-12-2015 at 10:40 PM.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
maybe use just .formula, not .formulaR1C1
Thank you so much guys! Its working now.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks