MS Excel: Value from a Range

Solved/Closed
Report
-
Posts
14
Registration date
Wednesday October 6, 2010
Status
Member
Last seen
December 11, 2010
-
Hello,

HDI get a numerical value (in C2) that is assigned to a word within a range(G2:H8)?

Thank you in advance!

1 reply

Posts
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
491
Hi Signora,

If the word you want to look up is in B2 then C2 contains the following formula:
=VLOOKUP(B2,G2:H8,2)

Just make sure you have your words in column G.

Best regards,
Trowa
2
Posts
14
Registration date
Wednesday October 6, 2010
Status
Member
Last seen
December 11, 2010

Oh, Trowa, You are my hero, this works like a charm (after sorted in ascending order) ! :)

(Now, HDI mark this query 'Solved'?)

Thanks again for your help, this is a BIG deal!
Signora
0