Merging 2 sheets

**vorabha** · 09-10-2009, 01:34 PM

does not understood your Q, which column is blank ?
STEP_INDEX or Job_id ??

if STEP_INDEX, then just replace last else statement of If with "NULL"
i.e. =IF(($E3="Null"),(VLOOKUP($A3,Sheet2!$A$2:$C$25,2,)),"null")

hope clear
if your Query solved, plz go to orignal post and mark as SOLVED

**rds207** · 09-10-2009, 02:01 PM

YES, there are some blank columns in step_index which i have to replace with Null and use the function to add runtime and queuetime different columns there is NULL...

**rds207** · 09-10-2009, 08:05 PM

Here is the link to my sheet could please let me know where and how to write the formula?

http://download.yousendit.com/cmcyT205WkJwM2xFQlE9PQ

I need to get queue time in sheet 2 whereever there is NULL in the stepindex column...

Please Reply

Thank you....

**Trebor76** · 09-10-2009, 10:24 PM

Hi rds207,

Let me know how the attached goes.

Just note that I switched columns in Sheet1 to enable the VLOOKUP formula in the Queue Time column to work. The formula will also return a blank if the Step_Index value is not (does not equal) "Null".

HTH

Robert