Quote:
Originally Posted by mquinn
This formula is perfect for what I am looking for but it is not working, I keep getting the #VALUE error.
I did CTRL+SHIFT+ENTER, made sure that all the numbers were numbers and not texts. Any other thoughts?
Below is the formula I did for mine.
CODE:
=INDEX(COLI!I:I,MATCH(MIN(ACOS(SIN(RADIANS(O2))*SI N(RADIANS(COLI!$E$5:COLI!$E$372))+COS(RADIANS(O2)) *COS(RADIANS(COLI!$E$5:COLI!$E$372))*COS(RADIANS(P 2-COLI!$F$5:COLI!$F$372)))),ACOS(SIN(RADIANS(O2))*SI N(RADIANS(COLI!$E$5:COLI!$E$372))+COS(RADIANS(O2)) *COS(RADIANS(COLI!$E$5:$E$372))*COS(RADIANS(P2-COLI!$F$5:COLI!$F$372))),0)+1,0)
|
This might be a red herring, but when I copied out your original posted code, it looked like there was a space between the P and the 2 in one of the cell references. When I quoted it above, I now don't see it, so it may just have been a display mirage.
Already bookmarked this thread, because I work with engineers who do use lat/long coordinates (and occasionally get to convert northing/easting to lat/long for them).