VLookup on multiple conditions

Hi Everyone ,

I am stuck at below excel sheet processing where i would to get value from other sheet/workbook based on cell values of this current sheet cells.
But im not able to get this .
Can you please help me to get this resolved

Attaching excel for reference

Cell G6 formula , Drag right

Formula:

Please Login or Register  to view this content.

Thank you it worked

hi slatad

You're Welcome. Glad to help . Thank You for the feedback.


If you finally get a solution please mark your thread as SOLVED:
- Click Thread Tools above your first post,you will see the word PREFIX on the upper left, press the button to select [SOLVED] select "Mark your thread as Solved".
- you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help
was given. By doing so you can add to the reputation(s) of those who helped.