Write just such a thing - =LOOKUP(D4;$A$4:$A$546;$B$4:$B$546)
It takes the value from D4, searches the array A4:A546, and returns to the found row value of column B.
But, for some reason this design works only if D4 5-digit number, if less, it returns #N/A..
Maybe I did something wrong formulas in the tables are not...
asked March 17th 20 at 09:50