MS Excel: Value from a Range

Solved/Closed
Signora - Oct 6, 2010 at 07:58 PM
GrnSpdr Posts 14 Registration date Wednesday October 6, 2010 Status Member Last seen December 11, 2010 - Oct 11, 2010 at 11:35 AM
Hello,

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

Thank you in advance!
Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Oct 11, 2010 at 09:16 AM
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
GrnSpdr Posts 14 Registration date Wednesday October 6, 2010 Status Member Last seen December 11, 2010
Oct 11, 2010 at 11:35 AM
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