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...
dumdiddydumdum Your formula tells VLOOKUP to look in the first column of the array for a match and return the value of the fifth column. With the set-up in your schedule you could change the lookup array to J36:K2, set the column number to 2 and use FALSE if it is the angle you want to return of course.