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


--
jesahs
------------------------------------------------------------------------
jesahs's Profile: http://www.excelforum.com/member.php...o&userid=30687
View this thread: http://www.excelforum.com/showthread...hreadid=503494