I have three columns of data A, B and C. Col A contains the results and col C the references.
How can I use a vlookup formula to look up column C, and return results in col A. As far as I can determine the sourced lookup reference must be on the far left hand side of the source data range, not in the middle or RHS....but I bet someone will know.
I don't want to change the order of cols A, B and C.
Thanks for your suggestions