Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Editing Lookup Formula Error
I've adapted the following formula from "How to lookup a value..." from
Office Online: =IF(ISERROR(INDEX($A$2:$F$1007,SMALL(IF($B$2:$F$10 07=G$1,ROW($A$2:$A$1007)),ROW(1:1)),1)),"",INDEX($ A$2:$F$1007,SMALL(IF($B$2:$F$1007=G$1,ROW($A$2:$A$ 1007)),ROW(1:1)),1)) date no1 no2 no3 no4 no5 1 6/7/2008 2 4 11 15 28 6/24/08 6/10/2008 8 13 14 23 30 6/28/08 6/14/2008 5 13 24 35 45 6/17/2008 10 12 18 30 36 6/21/2008 1 2 5 23 45 6/24/2008 1 4 37 45 46 However, the date that is returned is from the row BELOW the I would like. In other words, in column "1" the dates 6/21/2008 and 6/24/2008 should appear. Any suggestions? Many thanks. Bud |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dissabling Error when editing formula with Find+Replace | Excel Worksheet Functions | |||
Error Editing an MS Query in Excel | Excel Discussion (Misc queries) | |||
Lookup formula & an error to find the match | Excel Worksheet Functions | |||
Resource error when Editing Links | Excel Discussion (Misc queries) | |||
error message when editing a large spreadsheet | Excel Worksheet Functions |