if formula needed

snichols_24

New Member
Joined
Feb 8, 2005
Messages
14
Hi, can anyone help?

I need a formula that will return a simple yes or no to the question of is one cells data in one table duplicated in another table?

Hope that makes sense?

Thanks
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

acw

MrExcel MVP
Joined
Feb 13, 2004
Messages
4,814
Hi

=if(countif(secondtablerange,cell),"Yes","No")

where secondtablerange is the range that covers the "another table" in the above description, and cell is the address of the cell in question in the first table.


HTH

Tony
 

Watch MrExcel Video

Forum statistics

Threads
1,113,861
Messages
5,544,721
Members
410,630
Latest member
JFORTH97
Top