Good morning as a complete excel novice I am looking for some advice on using the vlookup function in excel to return a value in a new worksheet if it appears in another.

I have list of suppliers in worksheet C column A that also appear in worksheet A (Collumn A), I want to be able to insert the amount they owe if found in column P of worksheet A and enter it into column O in worksheet C.

I also need to do a similar lookup to a separate workbook but not sure if this is possible.

Thank you in advance