Help! compare 2 columns, different sheets, if value match copy the value of other cell

First if all, hello! My name is Adrian and I got here because I have to admit my knowledge of the excel is kinda poor, so is my friends knowledge. Hopefully I'll find help here.

So I have a workbook with 2 sheets. I need to the formula to copy the value from Col B Sheet1 in Col C Sheet2 where the value from Col C Sheet1 matches the value from Col A Sheet2, same row. I hope I wrote this clear.

sheet1.jpg
sheet2.jpg

Thank you in advance,

Adrian

Hi, welcome to the forum

You probably need to use VLOOKUP for this, but your data is a bit hard to separate Can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

Sure man, I wasn't expecting an answer that soon.

L.E. English is not my native language, just for the record. Thank you for your patience!

See if this is what you want...
=IFERROR(INDEX(Sheet1!B:B,MATCH(Sheet2!A7,Sheet1!C:C,0)),"Not Found")
copied down

haha thanks for the kind words, Im happy it worked for you

then INDEX/MATCH is a very useful combo for finding a single piece of data

syntax for INDEX = INDEX(range-to-search,row-to-use,column-to-use)

If you are only using 1 column (or row) to find your data in, you can skip the column (or row) to use

It then becomes...run down this column of data x-rows and give me what you find.

The next trick is to determine the row, and for that, we use teh MATCH function.

=MATCH(what=to-find, range-to search, 0) the 0 is for an exact match

Shout if you need more help