Comparing 3 columns? - microsoft.public.excel.worksheet.functions

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" <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?

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? > > . >

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? >> >> . >>

Similiar Articles:

Comparing 3 columns? - microsoft.public.excel.worksheet.functions ...
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...

How do you do an IF statement in Excel comparing three columns ...
how do I add 3% or 5 % to a column - microsoft.public.excel ... How do you do an IF statement in Excel comparing three columns ... how do I add 3% or 5 % to a column ...

Compare 1 cell to column of cells returning adjacent cells info ...
I want to compare the value in one cell to another column of cells in another work sheet and once the matching value is found I wan to return a diff...

Comparison of columns and calculate differences - microsoft.public ...
I have a formula to compare one column but I need a way to compare the 2 ... The formula will calculate the difference between the amounts in Columns B and D and format ...

Comparing Multiple Rows Across Multiple Columns from Imported CSV ...
I need to compare thirty+ rows (companies) across five columns (marketing indicators) and would like to output those companies that appear most fr...

Showing comparison w/out usning columns. - microsoft.public.access ...
I have a form that has information for different Products as they relate to certain properties. In the end I would like to compare 3 of the products i...

Compare two columns using loop. - microsoft.public.excel ...
Hi, Could you please help my create a loop which will compare each value in column A one by one with whole column B whether it contain value in c...

Compare two columns in a different worksheet - microsoft.public ...
Good day everyone, With the following code, you compare data between two columns in a different worksheet, and the results are transferred to a th...

compare two columns and pull out differences - microsoft.public ...
Excel columns are number and not Apha. - microsoft.public.mac ... compare two columns and pull out differences - microsoft.public ... Excel columns are number and not Apha ...

Compare entries in 2 worksheets and list what does not match ...
Compare entries in 2 worksheets and list what does not match ... Excel: Comparing Multiple Columns in 2 Worksheets, array formula ... If you want an exact match across 3 ...

Compare 3 columns - Computer Tech Support Forum - Windows - Linux ...
I have 3 columns with numbers in them. I want to compare all 3 against each other and see if any of them are not exactly the same. If possible put in another column a ...

How do I compare three columns in excel? - Yahoo! Answers
Best Answer: If the columns are A B and C that could or could not contain the "x's" then use this =IF(AND(A1="x", B1="x",C1="x"),"GOOD","BAD")

Compare 3 Columns excel [Solved] | Kioskea.net
Hello, I have to compare 3 columns (A,B AND C) filled with names and return, in another column (E), the list adding the names from the 3 columns (A+B+C-AB-AC-BC-ABC).

Excel: Compare 3 columns, countif, index formula
countif, index formula, fourth column: In this case I would recommend the use of an additional column (let s say E) with a formula like this on the second row, for ...

7/31/2012 5:20:40 AM