| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LOOKUP vs IF programming question
You're welcome!
tcek wrote: This worked very well..thanks "Glenn" wrote: It is a row number. When I selected the entire sheet by clicking on the square above the "1" and left of the "A", Excel put in the "D10_Sheet!1:65536". tcek wrote: what is the "65536" stand for in the statement? "Glenn" wrote: =INDEX(D10_Sheet!1:65536,MATCH(C12,D10_Sheet!A:A,0 ),MATCH(C10,D10_Sheet!1:1,0)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro Programming Question | Excel Discussion (Misc queries) | |||
| LOOKUP QUESTION | Excel Discussion (Misc queries) | |||
| Yet another lookup question | Excel Worksheet Functions | |||
| Lookup Question | Excel Worksheet Functions | |||
| Lookup question | Excel Discussion (Misc queries) | |||
Threaded Mode
