ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   using LOOKUP instead of IF on dynamic row (https://www.excelbanter.com/excel-worksheet-functions/21132-using-lookup-instead-if-dynamic-row.html)

Jay C

using LOOKUP instead of IF on dynamic row
 
Hello all, I was wondering if someone could help me out here. The
problem is this:
A row of dynamic length.
A second row in which I want to compare each cell to the dynamic row
and return 1 or 0. I can't have the next smallest value as I need
true/false results.
It isn't pretty with the IF but that is what I am using now, changing
the function in the cells to match the range where the value might lie
in the dynamic row. I just wanted a nicer way to make this happen.
I think it'll be HLOOKUP but I'm not sure how to set dynamic row length
or how not to return 1/0.
Any help is greatly appreciated.

Thanks

Jay



All times are GMT +1. The time now is 02:42 AM.

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