If Statement

[philb99]

Hi - looking for help please

I have 2 columns which vlookup values within my tab, they are Team Name last month / Team Name this month.

I wish to know if these change and report in Column 3.

I have about 7 different team names - for this example - North, South, East, West

 

[Special-K99]

So really you want to see if the Team Name from last month exsist in the Team name This month column

in C1
=IF(ISNA(ERROR(MATCH(A1,B$1:B$1000,0)),"Team does not exist","")
copy down the column

 

[philb99]

Many thanks, but I am getting an error in the formulae on "Error"

 

[Special-K99]

Try

=IF(ISNA(MATCH(A1,B$1:B$1000,0)),"Team does not exist","")

 

[philb99]

that's perfect if the Team Names are just typed into the Cell - My Team Names have been reported using a vlookup therefore I am not getting "Team does not exist".

Also as you know with a vlookup #NA is reported and I do receive a Team does not exist

 

[Special-K99]

I'm not sure what you are saying.

It doesnt matter whether a cell has a formula or a value. What matters is the content of that cell either obtained by entering a value or a formula.
VLOOKUP is irrelevant.

If this hasn't provided you with what you want then supply some data and inidcate whether they are the result of a VLOOKUP or manually entered data.