Vlookup

[dustinagee]

I am currently enrolled in an Excel course through my local college. We recently learned about the VLOOKUP function. It seems to be a very useful tool for work-related spreadsheets. Are there limitations of using this function? If so, what are they?

 

[MARK858]

https://exceljet.net/things-you-should-know-about-vlookup
https://trumpexcel.com/vlookup-vs-index-match-debate-ends/

 

[Michael M]

Not sure how to answer that....ALL functions have limitations !!!
Maybe have a read here about using VLOOKUP with working examples

https://www.contextures.com/xlFunctions02.html