matching and placing in cells

[gilnic]

Hello,
Would appreciate some assistance please.
I am trying to compare columns and enter “YES” in cells where appropriate.
In ColA from Row 5 to Row 40, there are names in the format 2. Red. These names change as each race starts.
In Cells AB6,AC6,AB9,AC9,AB13,AC13,AD13 names from ColA appear as a result of formulas. These are in three groups as in the sheet.
What I would like to be able to do is when there is a match from these Cells with an entry in Col A to place “YES” in the cell above the match. Example in sheet. If possible a formula to be placed in AB5 and in each of the other cells above the names,ie, AC5,AB8,AC8,AB13,AC13 and AD13.

[spitfireblue]

Something like this?

Please Login or Register  to view this content.

[gilnic]

Hello spitfireblue,
Thank you for your prompt response.
Now I am not sure if I am doing something wrong but when I enter the formula the result in AB5 is a name# error
as per attached.

[Sam Capricci]

you listed that you have MS office version 2013. You uploaded a .xls spreadsheet. the iferror formula he gave you does not work in .xls but will work in a .xlsx spreadsheet (2007 and later versions). If you can save the sheet as a later version of excel it will work. Otherwise for that to work it will need to be changed to an iserror formula.

[Sam Capricci]

for either version this should work ... =IF(ISNA(VLOOKUP(AB6,A:A,1,FALSE)),"no","yes")

[gilnic]

Hello Sambo Kid,
Thank you for your willingness to help and explain. I am operating two computers at the moment with different versions of Excel and when I tried it on my latest version it worked perfectly as you said it would.
So thank you and thanks to spitfireblue for the solution to my query.