How to find a value in a table and substitute it into another?

Question

excel

When using vpr, it gives an error, how can I solve this?

Answer 1

Hello!
Cell K3 contains the sum, and in the VLOOKUP formula, the first column is B, so the formula looks for the value 50000 in column B and does not find it there, because the sums are in column E. Perhaps you wanted to search for the sum by name.
In general, you can use, instead of the VLOOKUP function, the INDEX function, then you will not be tied to the first column and, in general, to the order of the columns.
Then, to find the amount by name, you can use the following formula:
=ИНДЕКС(E3:E21;ПОИСКПОЗ(K4;B3:B21;0))
If you need to find the name by the amount, then the formula will be:
=ИНДЕКС(B3:B21;ПОИСКПОЗ(K3;E3:E21;0))
If you need to find something else, please specify. From the example, I could not understand what you wanted to find with the formula

Answer 2

Most likely, the entries in K3 and column B are different (there may be spaces, invisible, English characters, etc.) Try to copy the value from the table and paste it into K3