Map cells based on text

[krishak77]

Hello Everyone,

i need yours help for the below situation

In the sheet1 i have multiple serial numbers, and for each serial number i have to check status and mention comment in Sheet2

in Sheet1 first serial number is on cell"L2" and for that status is on cell "A28" as Credit Accepted, so i have to mention comment as "Accepted" in Sheet2
second serial number is on cell"L52" and for that status is on cell "A78" as Credit Accepted, so i have to mention comment as "Accepted" in Sheet2
third serial number is on cell"L102" and for that status is on cell "A128" as system reject and in the comment cell"E127" we have "Cancelled as Serial number product mismatch", so i have to mention comment as "Cancelled as Serial number product mismatch" in Sheet2
forth serial number is on cell"L149" and for that status is on cell "A175" as Credit Accepted, so i have to mention comment as "Accepted" in Sheet2

Sheet1 data i will extract from webpage, so all the time it will be not in the same range.


attached excel file for your reference.

Appreciate for any solution for the above situation.

Thanks in Advance,
Anantha

[krishak77]

Hello Guys,

Can anyone please provide solution for the above situation.

Thanks in Advance,

[krishak77]

Hello All,

There is no Solution for the above situation?

Thanks in Advance,
Anantha Krishna

[mattreingold]

Upon looking over the workbook provided, I think having a more readable, concise and regulated format would aid a lot in procuring a solution, is this at all possible?