• 461K Members
• 5,214 Online
• 559K Conversations
SOLVED

New Contributor

# Problem with VLOOKUP

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
Solution

# Re: Problem with VLOOKUP

=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"

# Re: Problem with VLOOKUP

@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.

# Re: Problem with VLOOKUP

@Wyn Hopkinsworked perfectly. Thanks so much!

# Re: Problem with VLOOKUP

You’re welcome
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies