| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Index and match
I have a spreadsheet with 2 pivot tables side by side. One pivot table is
created using data from cash application and the other pivot table is from bank transactions. The two pivot tables are compared for missing data either in cash application or in bank. The data is the dollar amount obviously. I had used the formula =IF(COUNTIF(F8,"*Total")," ",INDEX(GLCC,MATCH(H8,GLCC,0),0)). GLCC is a name for a defined range and I wanted a blank if matching title has "Total". The formula mostly works but in lots of cases #N/A is displayed even though there is an exact match. If necessary I am willing to send the data as an attachment. I need help please. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Exact Match using INDEX, MATCH | Excel Worksheet Functions | |||
| index(match) Wind Uplift Calculations (match four conditions) | Excel Worksheet Functions | |||
| index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
| How do I display more than one match in a Index/Match formula? | Excel Worksheet Functions | |||
| index,match,match on un-sorted data | Excel Worksheet Functions | |||
Threaded Mode
