Vlookup if statements

[richardcookson]

Hi,

Im trying to do a 'Vlookup if' forumal as i only want the formula to return a one type of value within a column 'core capability'. If the column contains any other value i dont want the formula to return anything - is this possible.

Really appreciate any feedback on this.

Rich.

 

[JackDanIce]

Welcome to the board.

Yes it's possible, though you'll find you'll get a more constructive answer if you can give more detail/example of your data