Make the first array A1:A6 and not B6. Also, if the data in A1:A6 is not sorted, then you will
need to use the optional last argument in the MATCH function of 0 that specifies an exact match
must be found. If you don't want an exact match because you are looking for the closest number at
times, then the data needs to be sorted.

=INDEX(A1:A6,MATCH(C1,A1:A6,2))

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------



"Rod" wrote in message ...
I HAVE A FORMULA:

=INDEX(A1:B6, MATCH(C1, A1:A6,2))

ALL I GET IS #N/A



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.522 / Virus Database: 320 - Release Date: 29/09/2003