Question about comparing text columns in Excel?

H

hamdodger

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

hamdodger

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!
 
H

hamdodger

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula help, No VBA please 1
Comparing text in columns 18
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Importing data from Excel worksheet into Excel template 2
counting blank cells within two columns 2
Text to columns 2
summing two columns of different data 4
Excel Concatenate with line breaks but ignore blank cells 3

Top