ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   can you please help (https://www.excelbanter.com/excel-discussion-misc-queries/94285-can-you-please-help.html)

OSSIE

can you please help
 

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


Bob Phillips

can you please help
 
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





All times are GMT +1. The time now is 10:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com