formula #explaination

I know this is probably something simple that I am just not thinking of but I'm struggling here and wanted to see if I could get some advise! I have imported sales data into a spreadsheet over a large period of time, it has imported at one day per tab and has 133 tabs of unique data. I need to...

Hello all, I have a spreadsheet that contains a list of PO Numbers, the list may at times have the same PO repeated on different rows. I need a modification to my formula to be able to only show the result once if there is a duplicate row. Not sure of a way to do this so hopefully someone has...

Hello, I am using this formula --LEFT() instead of LEFT(), and I get different results, but I do not actually understand why. Can anybody explain what the -- does to the formula?

Can someone explain this line of code to me? It's too embedded to make sense. =IF(ISTEXT(VLOOKUP(LEFT($E4,5),SLTOwner!A:B,2,FALSE)),VLOOKUP(LEFT($E4,5),SLTOwner!A:B,2,FALSE),IF(ISTEXT(VLOOKUP(LEFT($E4,4),SLTOwner!A:B,2,FALSE)),VLOOKUP(LEFT($E4,4),SLTOwner!A:B,2,FALSE),"TBD")) Thank you.