vlookup problem

[TheIntern]

Hello everyone

Is it possible to use vlookup without sorting the colums in ascending order?
I need data from another sheet transfered without changing the order...any ideas?

Thanks in advance,

The Intern

 

[Gerald Higgins]

If you are using the FALSE argument then your data does not need to be sorted.
If you are using the TRUE argument, then if your data is not sorted, you may get the wrong results.