Vlookup in different sheets comparing columns

Hi

Is it possible to use multiple Vlookups in one macro?
Currently running a vlookup of computer names between multiple sheets, i need to be able to match product name and computer name between sheets.
For example (Sheet 2 column B) compare it to (sheet1 column B and C)
if it gets a match then vlookup to (sheet 2 column A) to (sheet 1 column A)

Spreadsheet attached
any help appreciated
thanks

if you can show an example or output, would be good

When run the two macros the orange highlighted ones outputted,
Sheet 1 row 20 and 21 have the same machine name but two different products
but the macro is highlighting both same
The concept of this is to highlight the machine name to product name together

hope this helps

thanks