View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hardeep kanwar[_2_] Hardeep kanwar[_2_] is offline
external usenet poster
 
Posts: 14
Default 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