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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
search without using sort (lookup function)
On Thu, 20 Mar 2008 06:47:00 -0700, Sam_sebai
wrote: 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. What if a1 and b1 are found on different rows? Try this =IF(MATCH(A1,Sheet1!$A$1:$A$10,FALSE)=MATCH(B1,She et1!$B$1:$B$10,FALSE),INDEX(Sheet1!$C$1:$C$10,MATC H(A1,Sheet1!$A$1:$A$10,FALSE),1),"No match") -- Dick Kusleika Microsoft MVP-Excel http://www.dailydoseofexcel.com |
Reply |
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 |