ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Look up cell range? (https://www.excelbanter.com/new-users-excel/210871-look-up-cell-range.html)

doss04

Look up cell range?
 
Is there a way to use a search field to find a range of cells? With the range
named from column D. If that makes sense.



Bernie Deitrick

Look up cell range?
 
You could apply a data filter to show all the cells in column D that match your criteria. Hard to
say more than that, given your question's brevity....

HTH,
Bernie
MS Excel MVP


"doss04" wrote in message
...
Is there a way to use a search field to find a range of cells? With the range
named from column D. If that makes sense.





doss04

Look up cell range?
 
I havent worked with filters yet. I will play around with it. Is there any
way i could show you a sample of what i have, if that would help with what
i'm doing.


"Bernie Deitrick" wrote:

You could apply a data filter to show all the cells in column D that match your criteria. Hard to
say more than that, given your question's brevity....

HTH,
Bernie
MS Excel MVP


"doss04" wrote in message
...
Is there a way to use a search field to find a range of cells? With the range
named from column D. If that makes sense.






Bernie Deitrick

Look up cell range?
 
Of course. Post a small sample of your data in a message, and explain exactly what it is that you
want to do.

HTH,
Bernie
MS Excel MVP


"doss04" wrote in message
...
I havent worked with filters yet. I will play around with it. Is there any
way i could show you a sample of what i have, if that would help with what
i'm doing.


"Bernie Deitrick" wrote:

You could apply a data filter to show all the cells in column D that match your criteria. Hard
to
say more than that, given your question's brevity....

HTH,
Bernie
MS Excel MVP


"doss04" wrote in message
...
Is there a way to use a search field to find a range of cells? With the range
named from column D. If that makes sense.









All times are GMT +1. The time now is 04:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com