Merging 2 sheets

[rds207]

I have 2 sheets

1st sheet data

Job_id Host_Name Outcome STEP_INDEX
742762 Blank success Null
742762 QCTCRMBLD07 success 0
742762 QCTCRMBLD02 success 1
742762 Blank skipped 2

2ND sheet data

Job id RunTime QueueTime

742762 52 .4562 0.12365

Now i have to insert the 2nd sheet data into the first sheet whereever the step index is NULL

So Basically my output should be like below:


Job_id Host_Name Outcome STEP_INDEX RunTime QueueTime
742762 BLANK success Null 52 .4562 0.12365 742762 QCTCRMBLD07 success 0
742762 QCTCRMBLD02 success 1
742762 BLANK skipped 2

Attached is my EXCEL SHEET, Please help!

[vorabha]

for Run time

=IF(($E2="Null"),(VLOOKUP($A2,Sheet2!$A$2:$C$25,2,)),)

for QUEUETIME
=IF(($E2="Null"),(VLOOKUP($A2,Sheet2!$A$2:$C$25,3,)),)

[rds207]

Thank you for the reply, if a column is blank , how do i replace it with NULL?

[vorabha]

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]

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]

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....