| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup between multiple columns | Excel Worksheet Functions | |||
| Lookup across multiple columns within multiple sheets | Excel Discussion (Misc queries) | |||
| lookup using multiple columns | Excel Worksheet Functions | |||
| Lookup in Multiple Columns, Return Multiple Values | Excel Worksheet Functions | |||
| Lookup + Sum multiple columns | Excel Worksheet Functions | |||
Threaded Mode
