#N/A error
#N/A error
(OP)
I am using the match function in cell k5 and k6. Every so often the cell k5 shows #N/A when I paste data into the highlighted cells. Can someone tell me what I can do to correct this error from happening? I have attached the spread sheet.





RE: #N/A error
RE: #N/A error
Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein
RE: #N/A error
Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein
RE: #N/A error
RE: #N/A error
Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein
RE: #N/A error
Use:
=IF(ISERROR(MATCH(J5,F1:F1061,0)),MATCH(-J5,F1:F1061,0),MATCH(J5,F1:F1061,0))
RE: #N/A error
You are using an absolute value as your lookup value, so the numbers in your lookup column must be absolute as well.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: #N/A error
You can also get problems if one is formatted as text and the other is a number.
RE: #N/A error
One thing to note, you have multiple values in the sheet that would be the maximum (at least as displayed for the 22.63), so you may have a different row with the same maximum.