Vlookup Error

[JadonR]

I am using the following formula:

=IF(A$24="Yes",(VLOOKUP(Y3,'Purchasing Units'![B]A:B[/B],1,FALSE)),"1")

I would like the vlookup to start at A3 instead of the entire A column, so I tried the following:

=IF(A$24="Yes",(VLOOKUP(Y3,'Purchasing Units'![B]A3:B50[/B],1,FALSE)),"1")

When I change the A:B to A3:B50, I get a #NA error (or sometimes #NAME). What am I doing wrong?

 

[snoopyhr]

Yes it is true, May be my assumption was not correct, since it was was not clear to me as what was expected if the cell which triggers the lookup case was left blank. so if the result is FALSE then the first condition was not met and should initiate to look back and investigate.