Hi there,

My boss has now come back and requested another option in the drop down box! This drop down would then need to bring up a different response from the IF formula.

The new option in the drop down menu would be 'Increase to benchmark' and it would need to bring up the word 'None' in the cell with the IF Formula. The 'None' doesn't need to be a hyperlink.

I'm trying to desperately work out where to place this in the IF Formula, you helped me out with above but it doesn't seem to like it!

I'm using =IF(E8="","",IF(E8="No","N/A",HYPERLINK("#"&IF(E8="Yes- Promotion Proposed","'Promotion Proposed'!A1","'Business Critical Increase'!A1"),"Click Here")))

Could you possibly help again? Thank you!