| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Best method to retrieve table data
No prob. Go with something which you feel comfortable with.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "D.Jessup" wrote in message ... Max, Thank you for your input, I did end up going with index and match: =IF(ISERROR(INDEX('Female Tables'!$BB$4:CO$73,MATCH(((AE3+AI3)-AM3),'Female Tables'!$BA$4:BA$73,0),MATCH(M3,'Female Tables'!$BB$2:CO$2,0))),"",INDEX('Female Tables'!$BB$4:CO$73,MATCH(((AE3+AI3)-AM3),'Female Tables'!$BA$4:BA$73,0),MATCH(M3,'Female Tables'!$BB$2:CO$2,0))) -- Just an ordinary Joe |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Change Data In Pivot Table | New Users to Excel | |||
| Another Exciting Data Table Question!!!! | Charts and Charting in Excel | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
Threaded Mode
