Excel EXCEL RECURSIVE

E

excelprob

Joined
Sep 6, 2012
Messages
2
Reaction score
0
Hi,

I have two columns with names in them and I want to check whether the names in the columns match and if not keep checking until it finds a match and display "yes" otherwise display a "no".

So I want a cell in say column B to check each cell in column A until it goes through the cells in the column. The two columns are not of the same length as in one column has less rows than the other one.

do I use a IF statement or a IFERROR statement? how do i go about it?

thanks
 
You would have to pair the formula up with one of the columns as far as which is a lookup and which is the array. For my example, I'll set up a formula that would work with 100 values in column A and 50 values in Column B. With column A being the longer Column, I will set that up as the lookup value and Column B as the array. The formula would then go in C1 through C100.
=IF(ISERROR(MATCH(A1,$B$1:$B$50,0)),"No","Yes")

Let me know if that answers the questions for you!
 
Back
Top