| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup across columns
Hello,
I have a column of text values and on another sheet I have five columns of text values (there are five columns because there are over 300000 records). I need a formula that will tell me if the text value in the first list appears anywhere in the five column list. -- Thanks in advance, MarkN |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| EXCEL should let me establish unlimited numbers of columns. | Excel Discussion (Misc queries) | |||
| Lookup Two Columns - Again | Excel Worksheet Functions | |||
| Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
| Hidden Columns in Shared Workbooks | Excel Discussion (Misc queries) | |||
| Lookup function skipping columns | Excel Worksheet Functions | |||
Threaded Mode
