Here are some problems that our users have asked and received explanations on
I need help with some excel functions for an assignment, specifically Vlookup, Left, Len and Iferror
Solved by Z. A. in 25 mins
Need to parse the data without using excel commands and by only using formula (=MID, =LEFT, =RIGHT, =LEN). I only have the classification and semester columns left, but I'm struggling to write the right formula to do so.
Solved by M. Q. in 17 mins
Hi there, could you please tell me what is wrong with this function: =IFERROR(VLOOKUP(LEFT(A4,4)&"_"&B4&"_"LEN(A4:B4),CustomerTable,2,FALSE),0). It is returning an error value and I am pretty sure it is to do with the LEN section but can't work it out
Solved by C. J. in 21 mins
Can you re edit this formula for me =IFERROR(IF(LEN(MID("RHS",1,FIND("RHS",B4,1)))=1,LEFT(B4,3),MID("RHS",1,FIND("RHS",B4,1))),MID("LHS",1,FIND("LHS",B4,1)))
Solved by S. L. in 24 mins
If I have inputs 4A, 3.5S, 8O, 2A, 8S, and 4.5O, how do I sum the numeric value for all those inputs containing "A?" I currently have the function, =VALUE(LEFT(G18,LEN(G18)-1)).