Lookup Value in Multiple Columns
 

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

Lookup Value in Multiple Columns
 

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

--
Biff
Microsoft Excel MVP


"Hardeep kanwar" wrote in message
...
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