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
2693
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 18, 2021
455
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!