Can anyone help me figure out why this webservice call isn't working? I know it's my XML filter, but I just don't know why. I see the result I want is there, I just can't get it into the cell!
Here's the WEBSERVICE result in my column labeled XML (result I want is bold and underlined):
Here's my XML formula:
Which results in the #VALUE error in the cell.
Any help is appreciated!