Need VBA to compare value of columns in different sheet and return value

Hi Experts,

I have two sheets, one that has "Details" and other "Final".

Here the sheet "Final" has column called "Status" and that is obtained by:
Comparing Manager, LOB and Level from sheet "Details" with Employee Level and Approved amount in sheet "Final".

If the approved amount is less than the allotted amount for that particular level then that Status should say "Under Limit" else "Above Limit"

For Example in row 1 of Final Sheet, approved amount $60 (for Beginner level under respective manager, lob) is within the limit in "Details" sheet
(i.e., Manager, LOB and Level - Beginner) hence status "Under Limit".

Status column should populate based on the comparison.

I would like to know if this can be achieved with formula or VBA. Please let me know if You need further information.

Thanks for any help that may be provided!

Details Sheet:
man1.jpg

Final Sheet:
man2.jpg

Thanks,
Richa

Richa,

Pictures are great but even better then pictures is a workbook. Uploading an example mockup workbook with explanations and expected results is better.

I have added a workbook with the example.

Please Login or Register  to view this content.

Richa,
You can click "Go Advanced" down to the rights and then use "Manage Attachments" further down on page.

I don't think attaching files should be so complicated. I have to think twice every time I am attaching a file i this forum. I understand if you have issues.

Regards
Joakim