# How can I use VLOOKUP, INDEX and MATCH to search about 3 criteria

1. ## How can I use VLOOKUP, INDEX and MATCH to search about 3 criteria

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?/

2. ## Re: How can I use VLOOKUP, INDEX and MATCH to search about 3 criteria

Without the workbook is really hard to guess. #ref is because the number given by index is out of the J2:n18 boundary.

3. ## Re: How can I use VLOOKUP, INDEX and MATCH to search about 3 criteria

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?

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1