MS Excel: Value from a Range
Solved/Closed
Signora
-
6 Oct 2010 à 19:58
GrnSpdr Posts 14 Registration date Wednesday 6 October 2010 Status Member Last seen 11 December 2010 - 11 Oct 2010 à 11:35
GrnSpdr Posts 14 Registration date Wednesday 6 October 2010 Status Member Last seen 11 December 2010 - 11 Oct 2010 à 11:35
Related:
- MS Excel: Value from a Range
- Ms excel mod apk for pc - Download - Spreadsheets
- Excel online macros - Guide
- Kernel for excel repair - Download - Backup and recovery
- Vat calculation excel - Guide
- Menu déroulant excel - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
11 Oct 2010 à 09:16
11 Oct 2010 à 09:16
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
11 Oct 2010 à 11:35
(Now, HDI mark this query 'Solved'?)
Thanks again for your help, this is a BIG deal!
Signora