Vlookup picking two columns and name of the worksheet

I know how to use Vlookup but I am unable to use it to pick 2 values, also picking the worksheet name. I am trying to match Mastersheet with other worksheets.

Attached is the sample sheet.Column highlighted in yellow is the output I am looking for.

Thanks

See if the attached works for you:

Please Login or Register  to view this content.

Regards,
Johan

I tried to test by changing the worksheetname "sheet1" to "test" but it is not working.

Thanks for your input

Originally Posted by berlan

See if the attached works for you:

Please Login or Register  to view this content.

Regards,
Johan

I tried to test by changing the worksheetname "sheet1" to "test" but it is not working.

Thanks for your input

Waiting for the solution.