What is the main basic difference between VLOOKUP
and LOOKUP
in Excel?
I read the main point is that you can specify a range of columns in VLOOKUP
and then pick one to return the value. However, it gets fuzzy because it kind of seems you can do something similar in LOOKUP
— is it just syntax?