Data Advanced Filter Problem

[dhaval123]

Dear Sir,
I am attaching sheet here with in which i have problem of data advanced filter.
When i am doing advanced filter work in cell g5003 i have written "Bank of Baroda A/c" but instead of this i am getting answer das A/c value written in cell d5003. Same is reflected in at end where i want result after data filter.

Kindly help me

Thanks,

[acerrhod]

TRY THIS FORMULA
=IF(ISERROR(VLOOKUP(A2,Sheet2!A:B,2,FALSE)),"SHIPPED",IF(VLOOKUP(A2,Sheet2!A:B,2,FALSE)=0,"TBA",VLOOKUP(A2,Sheet2!A:B,2,FALSE)))

[acerrhod]

Wrong post

[dhaval123]

Pl reply if can solve problem. i will be thankful.