MSGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

### Comparing 3 columns?

• Follow

```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?
```
 0

```=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?
```
 0

```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?
```
 0

```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" <cthompson17@discussions.microsoft.com> wrote in message
news:A9705B0C-B984-498B-8770-1015D14904F8@microsoft.com...
> 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?

```
 0

```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" <cthompson17@discussions.microsoft.com> wrote in message
> news:A9705B0C-B984-498B-8770-1015D14904F8@microsoft.com...
> > 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?
>
> .
>
```
 0

```Glad to help. Thanks for the feedback.

Regards,
Fred

"cthompson17" <cthompson17@discussions.microsoft.com> wrote in message
news:859BBC14-44B0-438D-BDE0-2FE0F17C8067@microsoft.com...
> 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" <cthompson17@discussions.microsoft.com> wrote in message
>> news:A9705B0C-B984-498B-8770-1015D14904F8@microsoft.com...
>> > 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?
>>
>> .
>>

```
 0

5 Replies
277 Views

Similiar Articles:

7/31/2012 5:20:40 AM