Forum Discussion
VLOOKUP or INDEX/MATCH Array Formatting Obstacles
PC/Windows 10 Enterprise MS Office Professional Plus 2019 I've been unable to resolve this lookup problem for a few days now. I believe it's a formatting issue, but I welcome any feedback. I...
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Alternatively, you can attach it to a private message to me.
Thanks for the reply, I wrote a response but it looks like I must have made some kind of mistake posting it because I can't find it. In any case, I seem to have identified the problem while creating a simplified workbook to share, so thank you for prompting me to do that. Ultimately it came down to formats, and because I'm processing data from an import to a data processing sheet to a summary sheet, it got away from me.