Bring same output from sheet1

[maddyrafi1987]

Attached sheet1(input) and sheet2 (output), here in sheet2 p column i bring the same output from sheet1 if borrowed id is same, suppose borrower id is not available in sheet1 then it remains the same in sheet2 p column

[PrimePorkchop]

not trying to be mean .... But I don't grasp what it is you're asking ... Perhaps if you explain why you are trying to accomplish this... What your end goal is, I could offer some help?

[maddyrafi1987]

sir, here attached 2 sheets, and here borrower id is unique and same i want to bring the sheet1 same product type in sheet2 p column suppose in 2sheets borrwer id is not same then the sheet2 p column remains the same there.

[PrimePorkchop]

I am still not 100% sure I am understanding what you are trying to accomplish - but I gave it my best guess... please see attached workbook and let me know if it accomplishes what you are trying to do.

[maddyrafi1987]

Everything is fine but See the P9 cell the output should be Water Filter need to come but it comes 0. here i want to check full column of sheet1, pls modify the formula and send me

[PrimePorkchop]

On the "Sheet2" tab, you'll notice that there is a hidden column (Columns appear to go in order Q, R, S, T, V) skipping the "U" column. That means the column is hidden.

Unhide "Column U" on Sheet two and add "Water Filter" to row 9 in Column U - then the formula in Column P will work properly.