Lookup Value in Multiple Columns

[Hardeep kanwar]

Hello Experts

Is it Possible Lookup value From Multiple Columns

See Below

Table1 Expected Result DataMangement
1 Found 1 2 8 3
2 Found 3 4 1 5
3 Found 8 1 7 2
4 Found
5 Found
6 Not Found
7 Found
8 Not Found
9 Not Found



Column A is the Table1 , Now i want to know whether the Value in Table1 is
Exist in Column M,N,O and P. If the Value in Table2 is Exist in Table1 then
it Show " Found" Otherwise "Not Found" or Blank.

The Value of Table1 is Exist in "Data management" It Doesn't Matter whether
it is in Column N or M or O or P

Thanks in Advance

Hardeep Kanwar

 

[T. Valko]

Multi-posted at Mr. Excel....

1 Found 1 2 8 3
2 Found 3 4 1 5
3 Found 8 1 7 2
4 Found
5 Found
6 Not Found
7 Found
8 Not Found
9 Not Found

You have 8 as Not Found yet there are 2 instances of 8 in the table!

If your tables are named:

=IF(COUNTIF(DataMangement,Table1),"Found","Not Found")

Copy down as needed