@EllaRoRo The VLOOKUP formula searches for a match of what's in B2 in the first column of the lookup range (i.e. column F) and then returns the value from the 2nd column (i.e. column G). Your intention is to find B2 in G and return F. That's where it goes wrong.
Now, you can make VLOOKUP to 'look left' by using the CHOOSE function, but I find that overly complicated. Better to use INDEX/MATCH or XLOOKUP if your Excel version supports it.
Then the formula would look like this:
Alternatively, and if you control the lay-out of the data, swap columns F and G, Then your original formula shall work as well.