Using an if(match statement?

[jackjack583]

Hey guys, what I'm trying to do is the following:

I want to make sure that if A1 matches any value within this range B1:B1826 (on a different sheet) then return the column C in that row.

For example, if A1=B453 return C453

Any help would be much appreciated!
Thank you

 

[jackjack583]

Thank you so much! My bad for not being clear.
Lifesaver!

 

[wideboydixon]

Thank you so much! My bad for not being clear.
Lifesaver!

You're welcome. Just try and bit a little clearer with your requirements next time

WBD

 

[jackjack583]

Of course! Just joined today haha :D