search without using sort (lookup function)

  • Thread starter Thread starter Sam_sebai
  • Start date Start date
S

Sam_sebai

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
 
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.
Click to expand...

What if a1 and b1 are found on different rows? Try this

=IF(MATCH(A1,Sheet1!$A$1:$A$10,FALSE)=MATCH(B1,Sheet1!$B$1:$B$10,FALSE),INDEX(Sheet1!$C$1:$C$10,MATCH(A1,Sheet1!$A$1:$A$10,FALSE),1),"No
match")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Check a value every time excel is loaded 1
Code does not error but no copy either 4
Search without sort in the sheet 1
Delete contents of cells in a range based on value of a cell 2
Excel VBA help: Text file formatting 19
Sorting, replacing data 1
Transpose code has ceased to transpose 3
Data Validation used with VLookUp function 1

Back
Top