jasonb75
Well-known Member
- Joined
- Dec 30, 2008
- Messages
- 15,509
- Office Version
- 365
- Platform
- Windows
A small weekend challenge for you all,
I've had a few occasions where it would be useful to combine ranges with array constants, as with the psuedo formula below. Got a few ideas for workarounds, which I won't post now to avoid any bias on your ideas, just wondered how others might do this.
=lookup(A1,{x,y,z,B1})
The values can be anything you like, text or numeric, x,y,z represent and number of hadwritten constants, B1 can be a single cell value or range but must form part of the array constant.
I'm going to be AFK for most of the day, will have a look and post my own ideas when I get back.
Thanks and good luck in finding something
I've had a few occasions where it would be useful to combine ranges with array constants, as with the psuedo formula below. Got a few ideas for workarounds, which I won't post now to avoid any bias on your ideas, just wondered how others might do this.
=lookup(A1,{x,y,z,B1})
The values can be anything you like, text or numeric, x,y,z represent and number of hadwritten constants, B1 can be a single cell value or range but must form part of the array constant.
I'm going to be AFK for most of the day, will have a look and post my own ideas when I get back.
Thanks and good luck in finding something