Formula only - Send values to another sheet if correspondent names are found

Hi everybody!
Please have a look at the simple workbook attached.

In sheet 1 I have a list of items with number sold in month "BBB" in column B

In Column C (with pink cells), I need to have the value of number sold from sheet2, but in sheet2 the order of the items is different.

While it is almost easy to do it with VBA, my client do not want to use macros.

And I found out I am not so good with Excel after all...

What I need is to insert the values (number sold) from sheet2 to sheet1, in column C, for every name, the right value.

I am looking for a formula, not vba code...

I am so very open to suggestion right now... A little help?

You can use this formula in C3 of Sheet1:

=IFERROR(VLOOKUP(A3,Sheet2!A:B,2,0),"")

then copy down.

Hope this helps.

Pete

It surely does! Thanks!

Alex

It works too! Thanks