| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looup Value and Return a Range
I want to lookup a value in column E and if it matches my lookup criteria I
want to return all the information in the corresponding row. A=acct number B=acct status C=acct code D=current balance E=previous balance If E=<=$1500 I want to return all the information in A:E |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Looup Value and Return a Range
Will there be 1 row that meets this condition or will there be many rows
that meet this condition? -- Biff Microsoft Excel MVP "pthutchison" wrote in message ... I want to lookup a value in column E and if it matches my lookup criteria I want to return all the information in the corresponding row. A=acct number B=acct status C=acct code D=current balance E=previous balance If E=<=$1500 I want to return all the information in A:E |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if range b6:n6 has no content, return A6 | Excel Worksheet Functions | |||
| Can VLookup return the LAST value in a range? | Excel Worksheet Functions | |||
| Return a value for a range of dates | Excel Worksheet Functions | |||
| return min. of range except 0 | Excel Discussion (Misc queries) | |||
| return a value based on a range | Excel Worksheet Functions | |||
Linear Mode
