Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Index Formula Returning a 0
I am using the index formula to read across a line of cells and return an
item code in one cell and the vendor in another cell. The index code is reading to return the item code and the vendor it belongs to that has the lowest price. My formula works on and off throughout some of the worksheets, but for some reason it returns a 0 in others. Why is it doing this and how can I fix it? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Index Formula Returning a 0
It's always best to include in your post either your code or
the formula you are haveing trouble with. Please do so. "nhuprich" wrote: I am using the index formula to read across a line of cells and return an item code in one cell and the vendor in another cell. The index code is reading to return the item code and the vendor it belongs to that has the lowest price. My formula works on and off throughout some of the worksheets, but for some reason it returns a 0 in others. Why is it doing this and how can I fix it? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Index Formula Returning a 0
And include the values of the "input" cells
-- Kind regards, Niek Otten Microsoft MVP - Excel "Jim May" wrote in message ... | It's always best to include in your post either your code or | the formula you are haveing trouble with. Please do so. | | "nhuprich" wrote: | | I am using the index formula to read across a line of cells and return an | item code in one cell and the vendor in another cell. The index code is | reading to return the item code and the vendor it belongs to that has the | lowest price. | | My formula works on and off throughout some of the worksheets, but for some | reason it returns a 0 in others. Why is it doing this and how can I fix it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Returning an array from the INDEX function | Excel Worksheet Functions | |||
Returning MULTIPLE values with Index and Match | Excel Discussion (Misc queries) | |||
Match/Index Returning #N/A | Excel Worksheet Functions | |||
HELP: Returning a value in an index | Excel Worksheet Functions | |||
Min formula not returning value from Index | Excel Worksheet Functions |