Condition from matches in two column Excel-CodePudding

I am working on a excel like this

I would like to create a condition from second table using matches between two tables columns values (Tool and tools) to automatically replace the column Unit prince

I want this result

<table>
| Tool | United Price |
| : ---|:------------:|
| Axe  | 5,9          |
| : ---|:------------:|
| Axe  | 5,9          |
| : ---|:------------:|
| Hoe  | 9,1          |
| : ---|:------------:|
| Drill| 7,8          |
| : ---|:------------:|
| Hoe  | 9,1          |
| : ---|:------------:|
| Hoe  | 9,1          |
| : ---|:------------:|
| Drill| 7,8          |
</table>

I tried to use VLOOKUP(A2; E2:F4; 2; FALSE), but it's don't work

CodePudding user response：

I think you want to use a

CodePudding user response：

Try =VLOOKUP(A2; $E$2:$F$4; 2; FALSE)

This will fix the position of the lookup array.