The Vlookup searches for a value in the leftmost column of a table, and then
returns a value in the same row from a column you specify in the table

Is is possible to use a lookup function to look up a value in the rightmost
column of a table and return a value in the same row from a column you
specify in the table (on the left hand side of the table) Basically the
reverse of the Vlookup

For example

I want to lookup the word black and return 5000

A B
1 5000 Black
2 1000 Red