“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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)).

Solved by F. S. in 15 mins