How to correctly find the value through Lookup()?

Question

openoffice

Hello!
I write something like this - =LOOKUP(D4;$A$4:$A$546;$B$4:$B$546)
It takes a value from D4, looks for it in the A4:A546 array, and returns the value from column B for the found string.
But, for some reason, this construction only works if there is a 5-digit number in D4, if it is less, then it returns #N/A
. .
Just in case, I attached the file itself - https://www.dropbox.com/s/rpqp1xbwpv5rztj/52538%20...
In it, each line is a page, for each page the ID of the parent page is indicated, but there is no name. With the formula above, I take the id of the parent page, look for a page with that ID, and display its title.
You can see an error, for example, in cell G44:
=LOOKUP(D44;$A$1:$A$546;$B$1:$B$546)
in D44 - 2260
in column A there is such a value four lines above, in column B the corresponding value "Tipper semi-trailers". So why does it return #N/A?
LibreOffice Calc 6.2.0 MacOS
Many thanks in advance!

Answer 1

The solution is -=VLOOKUP(D44;$A$4:$B$546;2;0)