Forum Discussion
vlookup na
is anyone able to point out why my lookup isnt working? I have made sure format for all referenced cells is the same, tried with false and true arguments for exact and approximate matches and tried...
Thank you both for your replies, my initial formula and intention was this:
The intention being looking up the MAX amplitude value and returning the angle.
I think this does not work because the column to return the value must be to the right of the column i am looking up? - if this is the case it seems a bit non-functional but it is workable.
I have used this theory and the previous suggestion of changing the table array and returning column 2 to solve.
Many thanks again,