Get instant live expert help on I need help with string to string array
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Search thru Column H and Column I, and IF the cell CONTAINs STRING A, STRING B, OR STRING C, return VALUE 1 OR if cell CONTAINs String D, String E, OR STRING F, return VALUE 2, OR if cell CONTAINs String G, OR String H, return VALUE 3 Otherwise, return UNKNOWN.
Solved by T. H. in 22 mins
MY QUESTION IS ABOUT:
Fixing Formulas
DESCRIPTION:
Search thru Column H and Column I, and IF the cell CONTAINs STRING A, STRING B, OR STRING C, return VALUE 1 OR if cell CONTAINs String D, String E, OR STRING F, return VALUE 2, OR if cell CONTAINs String G, OR String H, return VALUE 3 Otherwise, return UNKNOWN.
Solved by M. H. in 20 mins
I have an array in a single cell with 14 values and I am trying to match those values to string on a different sheet.
Solved by S. U. in 26 mins
I have 2 columns, string of characters in one and numbers in another. I want to see which number corresponds to a particular string, e.g in array below, what corresponds to "g".
a 1
g 5
v 7
g 9
n 3
n 8
w 0
f 6
Solved by C. U. in 11 mins
I need three simple array formulas:
- if "Y" then "abc", elseif "N" then "xyz", else = nothing.
- prefix whole column
- fill whole column with specified string
Solved by D. D. in 24 mins