Vlook up function support

[Iain170]

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.

Is this possible?

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

Thank you in advance

[JohnTopley]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Iain170]

O
I have added a simple workbook - I want to enter the invoice amount from worksheet one when the supplier numbers match

[Tony Valko]

This formula entered in B2 of Sheet2 and copied down:

=VLOOKUP(A2,Sheet1!A$2:B$10,2,0)