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
GrnSpdr Posts 14 Registration date Wednesday October 6, 2010 Status Member Last seen December 11, 2010 - Oct 11, 2010 at 11:35 AM
Related:
- MS Excel: Value from a Range
- Ms excel free download - Download - Spreadsheets
- Excel date format dd.mm.yyyy - Guide
- Number to words in excel - Guide
- Excel marksheet - Guide
- How to take screenshot in excel - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Oct 11, 2010 at 09:16 AM
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
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
Oct 11, 2010 at 11:35 AM
(Now, HDI mark this query 'Solved'?)
Thanks again for your help, this is a BIG deal!
Signora