I'm pulling what's left of my hair out. I have an existing, and working VLOOKUP function that every time I try to edit, it gives me the "There is a problem with this formula error." I can't figure it out and I've tried everything, including re-creating it on another new tab.
here is the formula:
=CONCATENATE("bridge group "|VLOOKUP(B281|MPLS|6|TRUE))
B281 = dropdown list of col 1 in MPLS table array
Sample of MPLS table array:
Albany NY, ALBY, x.x.x.237, x.x.x.170, 3020, ALBY-78539a
I'm trying to change the match approximation to FALSE, but any changes I make to the formula cause the error indicating col_index_num as unrecognizable.
Again, this works right now as is, but it's set for approximation and returns a bad result for one of the options. I'm just trying to change it to exact match and cannot.
Please help!
Bookmarks