Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question about comparing text columns in Excel?
I am trying to figure out how to create a Vlookup formula that would do the
following: I want to find the names in Column D that are not in Column A. Column A Column B Column C Column D Column E Name $$ amount Blank Name $$ amount Any suggestions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question about comparing text columns in Excel?
Check this out:
http://img138.imageshack.us/img138/3036/nonamed.png Micky "hamdodger" wrote: I am trying to figure out how to create a Vlookup formula that would do the following: I want to find the names in Column D that are not in Column A. Column A Column B Column C Column D Column E Name $$ amount Blank Name $$ amount Any suggestions? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question about comparing text columns in Excel?
Ah OK so that formula basically outputs that if an entry in column B isn't
found in Column A, it outputs "Not Exist" in Column C, correct? Very helpful and exactly what I was looking for! Thanks! "מיכאל (מיקי) אבידן" wrote: Check this out: http://img138.imageshack.us/img138/3036/nonamed.png Micky "hamdodger" wrote: I am trying to figure out how to create a Vlookup formula that would do the following: I want to find the names in Column D that are not in Column A. Column A Column B Column C Column D Column E Name $$ amount Blank Name $$ amount Any suggestions? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question about comparing text columns in Excel?
In that formula would I have to manually change the 'B1' value in each
subsequent cell in column C, or would Excel automatically be aware that if I'm applying the formula to cell C2, that the 'B1' value in the example would automatically become 'B2' then 'B3' etc.? "מיכאל (מיקי) אבידן" wrote: Check this out: http://img138.imageshack.us/img138/3036/nonamed.png Micky "hamdodger" wrote: I am trying to figure out how to create a Vlookup formula that would do the following: I want to find the names in Column D that are not in Column A. Column A Column B Column C Column D Column E Name $$ amount Blank Name $$ amount Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing Text between Columns | Excel Worksheet Functions | |||
Comparing two columns of text values | Excel Discussion (Misc queries) | |||
comparing two columns of text | Excel Discussion (Misc queries) | |||
Comparing Two Columns of Text | Excel Discussion (Misc queries) | |||
Comparing text in columns | Excel Discussion (Misc queries) |