G Guest May 22, 2004 #1 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
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 May 22, 2004 #2 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?
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?
