Vlookup inside an if formula

[saraapple]

I am trying to write and if statement that includes a vlook up if the answer is true. Where do I put the vlookup?
=IF(G12=1,"Y","N") is my basic formula how would I add the vlookup rather than it returning the value "Y"

Many thanks

 

[Trevor G]

This should guide you.

=IF(G12=1,VLOOKUP(Cell,Table,Column,False,"N")

 

[saraapple]

Thank you, I am getting a #value error!
This is my formula
=IF(G12=1,VLOOKUP('Time Changes'!A:F,5,FALSE,"N"))

 

[gaz_chops]

Think he missed the closing ) on vlookup, try

=IF(G12=1,VLOOKUP('Time Changes'!A:F,5,FALSE),"N")

 

[Trevor G]

Change
=IF(G12=1,VLOOKUP('Time Changes'!A:F,5,FALSE,"N"))
To
=IF(G12=1,VLOOKUP(G21,'Time Changes'!A:F,5,FALSE),"N")

 

[Fluff]

It should be
=IF(G12=1,VLOOKUP(G12,'Time Changes'!A:F,5,FALSE),"N")

assuming you are trying to lookup the value of G12

 

[saraapple]

Perfect thank you for your help

 

[Trevor G]

Happy to help and thank you for letting us know you have a working solution.