Excel: help needed with complicated multiple IF summation

I want to look into cell W7. If it is a number, then show that number. if not, then i want to do a vlookup(D7,'2017'!A:G,7,). However if there is no number in that vlookup, then go back to W7... if W7 says 'pre-arb' then display number 535000. if it doesnt say pre-arb, then display '-' here is what ive tried... =IF(ISNUMBER(W7),W7,IFERROR(VLOOKUP(D7,'2017'!A:G,7,),IF(W7="pre-arb",535000,"-"))) I can see it gets stuck after the isnumber function. so if there is a number in W7 it produces it, if not it returns zero. Im sure im just messing up the iferror part somehow, but ive become lost at what it is... probably something simple. any help? much appreciated!

This question generated 21 answers. To proceed to the answers, click here.

This thread is current as of March 17, 2017.

For more resources for Microsoft Excel