sikhwizard
New Member
- Joined
- Apr 24, 2014
- Messages
- 8
Hi,
Can some one guide me in creating a formula to get data from a spreadsheet. Effectively, what I am trying to do is;
If a row in column IVR = 2002,
and if the column = 2006,
Find value (Content) in that cell.
Anyone tell me if a IF function, or Index is the best way forward.
Thanks
<TBODY>
</TBODY><COLGROUP><COL><COL span=7></COLGROUP>
Can some one guide me in creating a formula to get data from a spreadsheet. Effectively, what I am trying to do is;
If a row in column IVR = 2002,
and if the column = 2006,
Find value (Content) in that cell.
Anyone tell me if a IF function, or Index is the best way forward.
Thanks
IVR</SPAN> | 2015</SPAN> | 2080</SPAN> | 2082</SPAN> | 2089</SPAN> | 2820</SPAN> | 6003</SPAN> | 6004</SPAN> |
2002</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> |
2008</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> |
2036</SPAN> | 1</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> |
2052</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 9</SPAN> | 0</SPAN> |
2053</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 44</SPAN> | 0</SPAN> |
2054</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> |
2072</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 3</SPAN> |
2098</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 43</SPAN> | 0</SPAN> |
2835</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 416</SPAN> | 1</SPAN> |
3021</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 1</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> |
3023</SPAN> | 0</SPAN> | 1</SPAN> | 2</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL><COL span=7></COLGROUP>