Formula to produce actual value as opposed to Y if cirteria is met

[RodneyW]

I'm using this formula

=IF(VLOOKUP($B6,Music!$E:$F,2,FALSE)="","N","Y")

and it works fine. I need to evolve it so that rather than producing a Y in the cell, it produces the exact value in the cell, unless the cell is empty in which case it produces N as it currently does.

Thanks in advance

 

[etaf]

=IF(VLOOKUP($B6,Music!$E:$F,2,FALSE)="","N",VLOOKUP($B6,Music!$E:$F,2,FALSE))

is 2013 still your version of excel

 

[RodneyW]

=IF(VLOOKUP($B6,Music!$E:$F,2,FALSE)="","N",VLOOKUP($B6,Music!$E:$F,2,FALSE))

is 2013 still your version of excel

=IF(VLOOKUP($B6,Music!$E:$F,2,FALSE)="","N",VLOOKUP($B6,Music!$E:$F,2,FALSE))

is 2013 still your version of excel

Worked perfectly, thank you. Yes, 2013 is still my version

 

[etaf]

you are welcome