Scan a table for data

[Andyaf]

Hi,

I need some basic excel help to validate if a certain piece of data is within a table. On the excel sheet above, there are two tables. The left table is a piece of data, the right table is a full list of data.

I would like be able to scan the right table and validate if the data from the left table is in the right table. (Yes or No)

Can this be done!

Thanks for your help!

 

[jayalaxmi]

=IF(SUMPRODUCT((F8:F12=C8)*(G8:G12=D8)),"yes","no")

see if this is the thing u want/need??

Regards,
Jaya

 

[jayalaxmi]

=IF(SUMPRODUCT((F8:F12=C8)*(G8:G12=D8)),"yes","no")

see if this is the thing u want/need??

Regards,
Jaya

 

[Khalid NGO]

Or this:
=IF(COUNTIFS(F8:F12,C8,G8:G12,D8)>0,"Yes","No")

 

[jayalaxmi]

amazing

 

[Deepak]

Or this:
=IF(COUNTIFS(F8:F12,C8,G8:G12,D8)>0,"Yes","No")

Hi,

">0" might be omitted..

=IF(COUNTIFS(F8:F12,C8,G8:G12,D8),"Yes","No")

 

[Deepak]

one more : =IF(SUMPRODUCT(--(F8:F13&G8:G13=C8&D8)),"Yes","No")

 

[Khalid NGO]

Hi,

">0" might be omitted..

=IF(COUNTIFS(F8:F12,C8,G8:G12,D8),"Yes","No")

Got it,
that means if count is greater than ZERO, it will automatically TRUE (without logical operator), and will FALSE if the result is ZERO.

interesting...
Thank you Sir.