Excel lookup problem

I have one worksheet which has certain information in and a seperate worksheet which has additional information in and i would like to extract one field from one and add it to the other

Each row has a unique reference number is on both sheets

So Sheet A looks like this for instance

A B C
1. Reference No. About me AdditionalInfo
2. 123456 this is
3. 567488 Help

Sheet B like this

A B
1. Reference No. AdditionalInfo
2. 567488 More info
3. 123456 Extract info

And basically for every row in Sheet A i want to refer to sheet B for that reference number, get the additional Info and then add it to the additional info cell in sheet A.

Can i do this without coding?

You can use VLOOKUP() for that.
Here's a link: http://www.excelfunctions.net/ExcelVlookup.html

Can't believe i didnt think of that! Sorry

So i have another issue. I have a third sheet which has rows in it with the same reference numbers in it, there are multiple entries for each reference number. From within sheet A I want to add in the count of how many times that reference exists in sheet C?

Hey, don't be sorry. If you didn't ask I'd have nothing to do. My wife would notice and she'd rectify that situation - quickly!

That would be the COUNTIF() function.

Here's the link for that: http://www.excelfunctions.net/ExcelCountif.html

Spot on once again, thanks