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!

1 reply

TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
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
2
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
0