How can I use VLOOKUP, INDEX and MATCH to search about 3 criteria
i use this formula
=vlookup(T5,J2:N18,index(K2:K18,match(U5,J2:N2,0)),1)
but result = #ref
why?/
How can I use VLOOKUP, INDEX and MATCH to search about 3 criteria
i use this formula
=vlookup(T5,J2:N18,index(K2:K18,match(U5,J2:N2,0)),1)
but result = #ref
why?/
Without the workbook is really hard to guess. #ref is because the number given by index is out of the J2:n18 boundary.
Perhaps if.....index(K2:K18,match(U5,J2:N2,0)),1)....is greater than 5? your vlookup range only has 5 columns
If you are trying to find 3 criteria, it may be easier to use a helper column?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks