How do I compare a value in one cell, to a value in a column, that looks at
the value in the adjacent column, to display in a cell?

For example: cell A1 = cindy; column B in cell B17 = cindy; and in the
adjacent cell, column C17 = 777. I would like the value of cell C17 to
display in a cell.

Does anyone know how to do this?

=VLOOKUP(A1,B:C,2,FALSE)

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"cthompson17" wrote:

How do I compare a value in one cell, to a value in a column, that looks at
the value in the adjacent column, to display in a cell?

For example: cell A1 = cindy; column B in cell B17 = cindy; and in the
adjacent cell, column C17 = 777. I would like the value of cell C17 to
display in a cell.

Does anyone know how to do this?

It's not working.....I keep trying, but nothing.
Suggestions?

I want to match the cell value in column A with the value in column B.
The value in each cell in column B relates to a unique identifier in column C.
So, in whatever formula, it first looks at A1, then tries to find a match in
column B. Once the match is found, it returns the value in a blank cell of
the value in column C - which is adjacent to column B.

Does that make sense?

"Ms-Exl-Learner" wrote:

=VLOOKUP(A1,B:C,2,FALSE)

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"cthompson17" wrote:

How do I compare a value in one cell, to a value in a column, that looks at
the value in the adjacent column, to display in a cell?

For example: cell A1 = cindy; column B in cell B17 = cindy; and in the
adjacent cell, column C17 = 777. I would like the value of cell C17 to
display in a cell.

Does anyone know how to do this?

The formula should do what you asked for. Why don't you tell us what you
"keep trying", and more detail on what's "not working".

Regards,
Fred

"cthompson17" wrote in message
...
It's not working.....I keep trying, but nothing.
Suggestions?

I want to match the cell value in column A with the value in column B.
The value in each cell in column B relates to a unique identifier in
column C.
So, in whatever formula, it first looks at A1, then tries to find a match
in
column B. Once the match is found, it returns the value in a blank cell
of
the value in column C - which is adjacent to column B.

Does that make sense?

"Ms-Exl-Learner" wrote:

=VLOOKUP(A1,B:C,2,FALSE)

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"cthompson17" wrote:

How do I compare a value in one cell, to a value in a column, that
looks at
the value in the adjacent column, to display in a cell?

For example: cell A1 = cindy; column B in cell B17 = cindy; and in the
adjacent cell, column C17 = 777. I would like the value of cell C17 to
display in a cell.

Does anyone know how to do this?

SUCCESS!!!!!
Thank you guys, that worked.
Not sure what was going wrong last night, but it works prefectly now!!

"Fred Smith" wrote:

The formula should do what you asked for. Why don't you tell us what you
"keep trying", and more detail on what's "not working".

Regards,
Fred

"cthompson17" wrote in message
...
It's not working.....I keep trying, but nothing.
Suggestions?

I want to match the cell value in column A with the value in column B.
The value in each cell in column B relates to a unique identifier in
column C.
So, in whatever formula, it first looks at A1, then tries to find a match
in
column B. Once the match is found, it returns the value in a blank cell
of
the value in column C - which is adjacent to column B.

Does that make sense?

"Ms-Exl-Learner" wrote:

=VLOOKUP(A1,B:C,2,FALSE)

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"cthompson17" wrote:

How do I compare a value in one cell, to a value in a column, that
looks at
the value in the adjacent column, to display in a cell?

For example: cell A1 = cindy; column B in cell B17 = cindy; and in the
adjacent cell, column C17 = 777. I would like the value of cell C17 to
display in a cell.

Does anyone know how to do this?

.

Glad to help. Thanks for the feedback.

Regards,
Fred

"cthompson17" wrote in message
...
SUCCESS!!!!!
Thank you guys, that worked.
Not sure what was going wrong last night, but it works prefectly now!!

"Fred Smith" wrote:

The formula should do what you asked for. Why don't you tell us what you
"keep trying", and more detail on what's "not working".

Regards,
Fred

"cthompson17" wrote in message
...
It's not working.....I keep trying, but nothing.
Suggestions?

I want to match the cell value in column A with the value in column B.
The value in each cell in column B relates to a unique identifier in
column C.
So, in whatever formula, it first looks at A1, then tries to find a
match
in
column B. Once the match is found, it returns the value in a blank
cell
of
the value in column C - which is adjacent to column B.

Does that make sense?

"Ms-Exl-Learner" wrote:

=VLOOKUP(A1,B:C,2,FALSE)

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"cthompson17" wrote:

How do I compare a value in one cell, to a value in a column, that
looks at
the value in the adjacent column, to display in a cell?

For example: cell A1 = cindy; column B in cell B17 = cindy; and in
the
adjacent cell, column C17 = 777. I would like the value of cell C17
to
display in a cell.

Does anyone know how to do this?

.