Hello,
I'm fairly new to power queries, I can speak regular excel language well, but seem to be stuck. I've been trying to switch a workbook that I use from indexing to power queries, but am getting stuck on some the "translations". I keep getting an error on my "else" and not sure why, I know it's case sensitive, I've tried everything in my limited power, but I'm stuck. Also included is the original 'if' statement that I'm trying to copy.
Bookmarks