SOLVED

Problem with VLOOKUP

Copper Contributor

Hey all! I have this formula that makes certain that the value in column G is set to "Confirmed", then if it is, I have it Vlookup  as so: =IF($G6="Confirmed",VLOOKUP($B6,$J$2:$N$7,3,$L$2:$L$7),"N/A"). So, here in lies my problem... if works for some of the categories in column B, but not others, as it returns #value.

 

Can anyone help me figure it out?

5 Replies
best response confirmed by ntscooby (Copper Contributor)
Solution

Hi @ntscooby 

 

=IF($G6="Confirmed",VLOOKUP($B6,$J$2:$N$7,3,$L$2:$L$7),"N/A"

 

The Bold part needs to be replaced by FALSE

 

=IF($G6="Confirmed",VLOOKUP($B6,$J$2:$N$7,3,FALSE),"N/A"

@ntscooby  Hi,  The last part of a VLOOKUP formula is usually a TRUE or FALSE value depending on whether an exact match is required or not. Remove the reference to $L$2:$L$7 and replace with 0 or 1 depending on your requirements and see what happens.

@Wyn Hopkinsworked perfectly. Thanks so much!

Thanks for your response!
You’re welcome
1 best response

Accepted Solutions
best response confirmed by ntscooby (Copper Contributor)
Solution

Hi @ntscooby 

 

=IF($G6="Confirmed",VLOOKUP($B6,$J$2:$N$7,3,$L$2:$L$7),"N/A"

 

The Bold part needs to be replaced by FALSE

 

=IF($G6="Confirmed",VLOOKUP($B6,$J$2:$N$7,3,FALSE),"N/A"

View solution in original post