Look in two work sheets for a value.

[sandralperkins]

Good day, please help me,

I have two sheets in a workbook.

Data Sheet and Complete Sheet.

Once the jobs complete I move that row from the Data sheet to the complete sheet.

I need a formula that will find a value by looking in both the two sheets.

See my sample attached.

Thank you.

[dilipandey]

Hi Sandra,


You missed the attachment...
To attach, click on Go Advanced while replying and look for paper clip icon. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>