Like this
=IF(A1="Y",VLOOKUP(A1,Sheet2!A1:H26,2,FALSE),0)
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"senthil" wrote:

how should i use vlookup & if condtion

Question
by using vlookup if result column contain Y, then if condition to be used
there. if result is N, then result should be 0