Referencing Multiple Columns

Ok here is something I have been trying to figure out for quite some time. I searched around the forums, but I believe I am not wording what I need correctly.

Pretty much I have an example here to follow:
x.....A.........B...........C
1 Name....Color.....Number
2 Bob.......Blue.......Five
3 Jan.......Red.......Three

What I want, is a formula that pretty much says search through column A for something, then show me what is in Column C that corresponds, in this cell.

So if i have a criteria for "Bob", I want it to return "Five". But I want it to be open, so that I can put bob or jan in another cell that it references.

Any Ideas?
I tried Vlookup, but i cant figure out how to get it to work, nor do i know if it would even do it.

~M~

But I want it to be open, so that I can put bob or jan in another cell that it references.

I don't know what that means, but anyway, look here:

vlookup sample.xls

Originally Posted by melegaunt

But I want it to be open, so that I can put bob or jan in another cell that it references.

~M~

Thats what i understood.We can change criteria.

Or Like second file We Can Put Criteria and result any where in the sheet