ExcelBanter - Looup Value and Return a Range

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Looup Value and Return a Range (https://www.excelbanter.com/excel-worksheet-functions/176867-looup-value-return-range.html)

pthutchison

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

T. Valko

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

All times are GMT +1. The time now is 05:27 AM.