I am using a lookup which works fine to a point....
J8 referes to "Projected Age Years"
F8 refers to "Projected Service Years"
however i am getting some funny results if the "F8+1 = 17"
this is all to do with some strange spreadsheet to calculate bonus payment, however you only get paid the bonus if more than one years service and over the age of 17...
how can i modify the vlookup to read, "=vlookup...work your magic, however if the f8 result=17 then "0")
hope that makes some sense