Forum Discussion

RichardH4's avatar
RichardH4
Copper Contributor
Aug 28, 2025
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, "...
excel
Formulas and Functions
  • RichardH4's avatar
    RichardH4
    Aug 31, 2025

    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!

RichardH4's avatar
RichardH4
Copper Contributor
Aug 31, 2025

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!

Resources