| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Table to Table
I have tried to make a formula to extract data from a table (not pivot) into
a grid when 2 variables are selected, but when I select the criteria I get nothing apart from 0. =IF(AND(D3<"",B12<""),OFFSET(Table!A1,MATCH(D3,T able!A1:A2206,0),MATCH(B12,Table!B1:DA1,0))," ") so that it will except any entry in D3 and B12 as long as they Match the table, but still I am getting no data pulled from the main table, does anyone see the flaw in my formula? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivit table- cell on spread sheet referencing pivot table field | Charts and Charting in Excel | |||
| entry removed from source table remains in pivot table pull down | Excel Worksheet Functions | |||
| PIVOT TABLE - Summary Table into a Databasae Table. | Excel Worksheet Functions | |||
| VBA Code for a pivot table to open database and to reference table current page | Excel Programming | |||
| create a source table from a special pasted value dynamic crossed table | Excel Programming | |||
Threaded Mode
