ExcelBanter - formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - formula (https://www.excelbanter.com/excel-discussion-misc-queries/126599-formula.html)

senthil

formula

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

John Bundy

formula

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

All times are GMT +1. The time now is 10:45 PM.