a lookup question please

[Pauls123]

Hi, I am trying to work out a formula wherein I am running a lookup on a certain worksheet (excel 2010), say in column O I have a heaps of names.

I now want to match the names but to a set of figures and names I have on a different worksheet, lets say the worksheet is called ABC, and they fill up columns A and columns B on that other worksheet. With Column A having the names in it, and column B having figures in it.

Is there a formula for this please,

Regards, Paul

 

[VoG]

Try VLOOKUP http://www.contextures.com/xlFunctions02.html

 

[Aladin Akyurek]

Care to clarify a bit more what is matched against what, and what result must be produced?

Example:

MATCH(X2,F2:F100,0)

This matches X2 against F2:F100. X2 is called a look up value and F2:F100 a match range.
The 0 stands for the type of match, which is here an exact match.

 

[Pauls123]

ah haaa,..I just figured it out, thanks everyone,

Regards, Paul