Hi,
with xlookup is there a way to make the return array dynamic so i could I've tried nesting a match function, but this give a number which I then need convert to the range, so tried using sequence, got stuck.
Workbook attached.
My formula is ;
It's just a range , but I'd like the return part to change in relation to the column name,Please Login or Register to view this content.
I've tried using index match,Please Login or Register to view this content.
for the return but not got it working, any ideas,Please Login or Register to view this content.
Richard.
Bookmarks