Here's my problem. I need to figure out how to nest a HLookUp function within an IF function. If the hlookup finds the number in a seperate worksheet, then I need it to display that in the cell, otherwise, if the hlookup does not find the number, I just need a blank space.

I can't use the ISERROR function because of all the additional code that would need inputting. I was hoping that I could figure out a way to assign the HLookUp formula to a variable to reduce the calculation time as well as the code size. Here's an example:

IF(a,a,"")

which would be this:

IF(HLOOKUP("Order",TrackingGantt!$A:$Z,MATCH($J20,TrackingGantt!$B:$B,FALSE),FALSE),HLOOKUP("Order",TrackingGantt!$A:$Z,MATCH($J20,TrackingGantt!$B:$B,FALSE),FALSE),"")

or something similar.

Thanks