Forum Discussion
Solved
Vlookup returning random #NAs, Randcom Correct Responses
I have a multi-sheet workbook, with a named array of data. On a separate sheet I cite a first-column text of that named array, to extract datum from a column on that specific row. In other words, "...
Thanks for the advice, especially about the Xlookup. For some reason, the formula now works. (Same formula as before!) Very mysterious; would love to have some ideas how/why this glitchy period happened in case it happens again. But for now, I'll call the problem (the formula) solved, even though the real problem for me was not understanding why such a result would occur so serendipitously!
yes unfortunately it does prevent posting files of new members and can be glitchy. That said you can share a link to a web hosted version of the sheet (e.g. one drive or google drive)
as for the problem you mention using vlookup but are you specifying exact match (a 0 at the end)?
also consider using XLOOKUP