Attached is a test spreadsheet that shows the issue.
VLOOKUP fails in the special case where all of the following is true:
“approximate match” is set to TRUE
the vlookup range only contains a single row
the range star…...worksheets["Sheet1"] listOf( "just one vlookup true, false, A539:D539...A539:D539,2,FALSE)"), "just one vlookup true, false, A1:D1 --...