Hello!
I'm beginning to work with Index/Match nested functions and I'm running into a problem with a few particular cases. In the attached document, LIV2172 and LIV2236 in the Summary tab are showing the wrong city in column B and I'm not sure why since they're using the same formula as the other 20 or so lines that are working. Can someone please tell me if my formula structure was wrong or if there's a better way to accomplish what I'm trying to do?
Thanks,
Nate
Bookmarks