Hello !!! Please I need your advice for this situation,, I have 2 textbox, I need to make a condition that in case I put value in textbox1 so I must put value in textbox2 Thank you in advance ...
loved the lesson Chester. Quick question: what's the benefit of using your alternative vs a) utilizing an OFFSET (with MATCH) to make the return arrays within the XLOOKUP flexible/not contiguous based on the queried criteria? If the queried fields are several (let's say 50), the need to select each of the queried ranges in your option is a bit taxing. or another solution I found is b) an INDEX (combined with SEQUENCE and XMATCH), again to make the return array within the XLOOKUP totally flexible/not contiguous. Again, loved the lesson.
Sir, I have a question - I have a large dataset and I am using the Filter function to have a custom range with few columns. So my filtered data has 6 columns and the range starts from A2. Now I'm using xlookup on the filtered data and for the 'lookup array' I am referencing A2# and it is selecting the entire lookup table accurately. But for the 'return array' I am not able to do this dynamically using the # sign. Can you help me solve this? The no.of rows in my data will increase depending on a condition used in the Filter function.
XLookup doesnt work and shows #SPILL! when the ranges are translated to tables as table1 and table2. Do you know how to make them work if the ranges are 2 excel tables?
simply brilliant. Thanks Chester
I love this use of choose with xlookup. Unfortunately this must be a taxing combo since excel crashes if I ever make a whole column of this
excellent video. Would you make a video on how to build excel PMS(Progress Measuring System) for a Project.
Hello !!!
Please I need your advice for this situation,,
I have 2 textbox, I need to make a condition that in case I put value in textbox1 so I must put value in textbox2
Thank you in advance ...
loved the lesson Chester. Quick question: what's the benefit of using your alternative vs a) utilizing an OFFSET (with MATCH) to make the return arrays within the XLOOKUP flexible/not contiguous based on the queried criteria? If the queried fields are several (let's say 50), the need to select each of the queried ranges in your option is a bit taxing.
or another solution I found is
b) an INDEX (combined with SEQUENCE and XMATCH), again to make the return array within the XLOOKUP totally flexible/not contiguous.
Again, loved the lesson.
Nice job. Please n please put its excel file in the description ....
I've now but a link in the description. Hope this helps.
Question. Is it possible to combine non-contiguous lookup_arrays? For example cells A2:A7 and D2:D7 contain would be the lookup_array data.
Sir, I have a question - I have a large dataset and I am using the Filter function to have a custom range with few columns. So my filtered data has 6 columns and the range starts from A2. Now I'm using xlookup on the filtered data and for the 'lookup array' I am referencing A2# and it is selecting the entire lookup table accurately. But for the 'return array' I am not able to do this dynamically using the # sign. Can you help me solve this? The no.of rows in my data will increase depending on a condition used in the Filter function.
XLookup doesnt work and shows #SPILL! when the ranges are translated to tables as table1 and table2. Do you know how to make them work if the ranges are 2 excel tables?
Unfortunately you can't use a "spilling" formula in a table.