Forum Discussion
Solved
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"...
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"
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"
Wyn Hopkinsworked perfectly. Thanks so much!
