Vlookup with if statement

=IF('Quote Info'!B26="n",VLOOKUP('Quote Info'!C19,[Mtlspecs.XLS]Material!$A$9:$S$159,5,VLOOKUP('Quote Info'!C19,Mtlspecs.XLS!TUB,3)))


Can anyone look at this formula and see why it is not working correctly. I can upload files if that is going to be needed.

I am 100% positive there is a n in the B26 cell of the IF Statement.

Problem:
the formula is going all the way to the last VLOOKUP STATEMENT. If i understand correctly it should stop at the first VLOOKUP ( True) because the if statement is true ,
there is without a doubt an n in B26.

i am assuming it is syntax issue but for the life of me i can't get it right.

Thanks

Hi,

I think you'll need to upload the wb so that we can see the formula in context. Are you sure B26 doesn't have say "n ", i,e, with a trailing space?

Rgds

Maybe

=IF('Quote Info'!B26="n",VLOOKUP('Quote Info'!C19,[Mtlspecs.XLS]Material!$A$9:$S$159,5,0),VLOOKUP('Quote Info'!C19,[Mtlspecs.XLS]TUBING!,3,0))

Bingo !!! That was it, closed parens and needed the false part of the VLOOKUP. learned a valuable lesson on that one. thanks so much for the fix.