'=VLOOKUP(1088,CHOOSE({1,2,3},$D$5:$D$17,$B$5:$B$17,$C5:C17),2,0)
If we search for the value in Array: $D$5:$D$17 and then return corresponding value from the array: $B$5:$B$17
Then why do we bring up array:$C5:C17?
----------------------------------------------------------------------
What does this function do individually without being used in VLookUp function?
=CHOOSE({2,1},$B$5:$B$17,$D$5:$D$17)
What is the role of 2 here?
We always select from the first array which is array 1, then what does 2 do in choose ({2,1})?
When I do F2 and F9, this is what I have in array: 1592,"Joseph"
That returns:1592
Any help is greatly appreciated.
Thanks,
GN