didn't work on spreadsheet of google drive for me, but i made it with choosecols that end up making also an array, =vlookup(C2,choosecols(B:C,2,1),2,0)
The video is about how VLOOKUP can be used to the left direction. Not about INDEX and MATCH. ;) I would have used INDEX and MATCH too. And even XLOOKUP.
my excel didnt creating table when using CHOOSE function with array
Did you get any errors?
What version of Excel are you using?
didn't work on spreadsheet of google drive for me, but i made it with choosecols that end up making also an array, =vlookup(C2,choosecols(B:C,2,1),2,0)
Not surprised at all. Not all Excel functions will work the same way in Google Sheets.
Nice
Thanks
Paano po gwin yang maliit na table na may yellow sa taas?
Hindi Yan "ginagawa". Meron Ka na Nyan dapat.
takes too long to come to the point
USED INDEX(MATCH). CHOOSE IS TOO COMPLICATED
The video is about how VLOOKUP can be used to the left direction. Not about INDEX and MATCH. ;)
I would have used INDEX and MATCH too. And even XLOOKUP.
VLOOKUP(A2,{W:W,P:P},2,0)