| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
search without using sort (lookup function)
how can i search for a string in a selected column without using lookup
function: Here is what I need: if (a1=sheet1!a1:a100) and (b1=sheet1!b1:b100) then put in the current cell the value of sheet1!Cxx where xx is the row that the condition was met. Thank you so much |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need a search/find/lookup function | Excel Worksheet Functions | |||
| LookUp Function with Two Column Search Returning One Column Value | Excel Worksheet Functions | |||
| If statement with some sort of lookup function | Excel Worksheet Functions | |||
| Lookup function experts.. I need ascending and decending lookups of a series of data.. can you help me sort this out | Excel Worksheet Functions | |||
| How do I expand Excel lookup function to search more than 16,384 r | Excel Programming | |||
![Sam_sebai[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
