Felix Anand

@orm_skeptic

Fullstack dev who writes raw SQL by choice. I like knowing exactly what hits the database, even when it costs me an afternoon.

Joined October 7, 2024 · 0 followers

VLOOKUP returns N/A even though I can see the value on the other sheet

Also confirm the lookup column really is the first column of your range. VLOOKUP only searches the leftmost column of the array, so if somebody inserted a column into Orders your A:D no longer starts where you think it does. This is why I moved everything to XLOOKUP — separate lookup and return arrays, no column counting, and it does not silently break when a column is inserted.

121 · in/spreadsheets ·