of all the tutorials ive seen this is genuinely the simplest and easiest to understand
@excelisfun
8 жыл бұрын
Thanks for the left-ness of VLOOKUP!!!
@purenrg4life
8 жыл бұрын
If it makes you feel better, an example of a time this would be useful is if your company has its own software that spits out excel exports in a certain format that you can't really change .. I've used index and match to have the calculation sheet be able to find the data without having to always rearrange the 'output sheet' .. But yeah.. If I could I would've just moved the columns and vlookedup! Thanks for your videos.. Huge fan here in Switzerland
@DavidB-dp3we
8 жыл бұрын
I use =VOOLKUP(A2,(CHOOSE({1,2},E3:E11,D3:D11),2,0)
@rodelmar1
8 жыл бұрын
Thanks Excelent Job!!
@JoeG2324
8 жыл бұрын
you would think by now microsoft would have adressed this issue by now
@douglasbrown5329
5 жыл бұрын
Yes, INDEX MATCH works very well....isn't DGET also a good alternative to Vlookup?
@deancorleone
8 жыл бұрын
=vlookup (choose {1,2} formula can look left
@Big_Tex
8 жыл бұрын
Wait, so you give us the tip and then tell us you don't like it and we should ignore it??? I just wasted 3 minutes!! ;)
@samehm2841
8 жыл бұрын
The way i see it .. he demonstrated two solutions for the problem ...
Пікірлер: 10