ctrl + shift & enter

G

Guest

What does ctrl + shift & enter do? Without it this formula would not work for me =INDEX(A1:C1,MATCH(TRUE,ISNUMBER(SEARCH("probe",A1:C1)),0)) With it it worked. Could someone explain
 
P

Peo Sjoblom

Please refrain from multiposting, see answer to your previous post

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

Lee said:
What does ctrl + shift & enter do? Without it this formula would not work
Click to expand...
for me =INDEX(A1:C1,MATCH(TRUE,ISNUMBER(SEARCH("probe",A1:C1)),0)) With it
it worked. Could someone explain?
 

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

Interpretation for: =INDEX(MATCH(1 <--one 3
question on SUMPRODUCT ?? 4
formula issues 7
Adding if error to a formula 6
What is Ctrl + Shift + Enter ? 6
Look up one number based on mulitple criteria!!!! 20
Array function does not seem to work 19
Jack 2

Top