Is there a way to build/use hash tables in Excel ?

E.g.
My table contains

... 2.
.... ...
value_n 2.5
value_n+1 2.6
value_n_2 3.4
....
....

I am pretty sure the stuff on the left column occurs only once, but I
don't know what row value_n (or others for that matter) exist, and
their order changes every time I import my data from elsewhere.

Instead of using Control + F to find these and then find their values
(since I have a lot of these), I was wondering if there's a way to
build a hash table so I can use a formula like... $MYHASH{value_n} to
get either the value 2.6, or the row/col address so I can work
something out.

Can we do this?

Mahurshi Akilla