Lookup query

Hi all,

Can someone please help?

I am having problem matching one column with another, In column One on tab 1 is a list of peoples names eg Joe Bloggs and the same is in colume one tab two.

what I'm trying to do is match them, eg if Joe is on tab 1 and on tab 2, then the formula will say yes or no.

I have tried this using "Match", but I'm unable to get it to work, or am I barking up the wrong tree?

Many thanks

It's not immediately clear to me, but it sounds like what you're looking for is a check on whether or not an entry in column X row x is the same as that in column X+1 row x+1... If that's the case, then copy down a formula of the form:

=if(A1=B1,Yes,No)

Here I'm assuming the first two columns (A,B) hold the people's names and you would copy the formula down some other column.

If you're actually looking to match the names, you can always use isolated sorting, provided these two columns are the only ones in the table i.e. no other column data is present.

HTH

Alex

akexcel,

Thanks mate,

Clash.