DonAndress
Active Member
- Joined
- Sep 25, 2011
- Messages
- 362
- Office Version
- 2019
- 2016
- Platform
- Windows
Hello.
Is it possible to create a formula that would use MID in an array of VLOOKUP?
Say, like below:
When the array is like a normal range, vlookup returns what I wanted but when I add MID (and I know exactly starting point and no of characters) it returns #VALUE!.
Is it the only way to create MID function in a separate range and then define VLOOKUP to search in that new range?
Is it possible to create a formula that would use MID in an array of VLOOKUP?
Say, like below:
Code:
=VLOOKUP(N4,MID(RedbReds!J4:J30,33,11),1,FALSE)
When the array is like a normal range, vlookup returns what I wanted but when I add MID (and I know exactly starting point and no of characters) it returns #VALUE!.
Is it the only way to create MID function in a separate range and then define VLOOKUP to search in that new range?