Match 2 criterias and return a value

Hi guys

I need some help on a formula:

I have a spreadsheet with multiple columns and sheets, and need to match 2 criteria's and return the value if these two criteria's match

example in Col A Col B Col C
55 55 1203.45
66 4522.56
1012
1402

What I want to do is an exact match Col A to (=) Col B and then return the value of Col C, so 55 = 55 and return 1203.45. I have about a 1000 rows where I need to match Col A to B and return Col C

Appreciate it
Peter

Hi Sixthsense

That works great and I'm sorry but actually explained it very stupid, Col A for example is 55 then the formula needs to go and look for 55 in Col B and then return the value of Col C

Let me try again with an example:
Col A = 55
Col B = 55 or 66 or 1011 - there are almost a 1000 different numbers in Col B
Col C = 120.50

So the formula needs to be something like if Col A is an exact match for Col B and in this case = 55 it must return the value in Col C which is 120.50

I apologise for my bad explanation in the first place

Regards
Peter

Hi sixthsense

Please see attachement - Hope this helps

Hi Greggy99

Attached is a small upload file - I think I'm going to need some sort of VLookup file

Pls see if you can help

Regards
Peter