Excel forum within a range
Solved/Closed
Gerberreinette
Posts
14
Registration date
Friday March 4, 2016
Status
Member
Last seen
July 31, 2023
-
Apr 21, 2017 at 08:09 AM
Gerberreinette - Apr 24, 2017 at 08:45 AM
Gerberreinette - Apr 24, 2017 at 08:45 AM
Related:
- Excel forum within a range
- Excel marksheet - Guide
- Number to words in excel - Guide
- Excel apk for pc - Download - Spreadsheets
- Kernel for excel - Download - Backup and recovery
- Gif in excel - Guide
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Apr 21, 2017 at 10:55 AM
Apr 21, 2017 at 10:55 AM
Gerberreinette, Good morning.
Try to use:
F2 -->
=INDEX($A$2:$A$7,MATCH(VLOOKUP(E2,$B$2:$B$7,1,TRUE),$B$2:$B$7,0))
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Try to use:
F2 -->
=INDEX($A$2:$A$7,MATCH(VLOOKUP(E2,$B$2:$B$7,1,TRUE),$B$2:$B$7,0))
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Apr 24, 2017 at 08:45 AM