If A2 has the value 4, it will show the 4th item.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"OSSIE" wrote in
message ...

Hi can anyone here tell me whats wrong with this formula
=INDEX(COSTINDEX,A2,) because when i entered the number for the index
item that ineed from the data sheet its skipping the first 3 entries
and shows me the 4 itme on the list and so for, i thank you all for you
help im doing my best learning excel but its sometimes some what
dificult to understend the formulas ones again
Thank you for all you help any ideas or suggestion its greatly
appreciated


--
OSSIE
------------------------------------------------------------------------
OSSIE's Profile:
http://www.excelforum.com/member.php...o&userid=31638
View this thread: http://www.excelforum.com/showthread...hreadid=552498