Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Basic INDEX(MATCH()) Question:
I am currently using an INDEX() function to do a basic data retrieval by
specifying both the collumn and rows. INDEX(p1rn1,1,18) p1rn1 is C2:AE28 the 1,18 retrieves what is in cell T3 in cell Q:S3 (Cells Q3 - S3 are merged) is the text string "Weap Dam Rec" Is it possible to use INDEX(p1rn1,MATCH("Weap Dam Rec",?,?),?) to find the data in T3, if so, what is the wording of the function? If INDEX() can't do it, is there anyhting that can? for the billionth time Thanks Adam |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Basic Pivot Table Question (using 97) | Excel Discussion (Misc queries) | |||
basic question on typing names on spreadsheet- problem | Excel Discussion (Misc queries) | |||
Help - basic formula question | Excel Worksheet Functions | |||
Very basic question - how long can a list be? | Excel Discussion (Misc queries) | |||
basic pie chart question | Charts and Charting in Excel |