Hi all

I'm trying to set what is probably a very basic vlookup instruction but have no idea. I've never used vlookup before - I've only just discovered conditional formatting!

Anyway, I would like to do the following:

If a cell in column F contains 'y' I would like to copy the data from column B to column H in the same row.

Any help with this would be greatly appreciated. Many thanks in advance.