Forum Discussion
How to use XLOOKUP in scenario where I want the latest date with AVAILABLE data?
PeterBartholomew1 Hi Peter - thank you so much for providing the XLOOKUP and IF formula! I did not know we can use the formula like that!
May I follow-up regarding the IF function within the XLOOKUP:
1) First, lookup value is country (e.g. Chile)
2) We use IF function and include % Fully Vaccinated Data, why? Because we didn't put in value if true or value if false, so what is the purpose of this?
3)Then afterwards I understand we want the return array back to Xlookup formula
Thank you,
Amy
1) First, lookup value is country (e.g. Chile): Correct
2) We use IF function and include % Fully Vaccinated Data, why? Because we didn't put in value if true or value if false, so what is the purpose of this?
Rather than looking for the country in the original list, I look for it in an array that is modified to show FALSE if there is no data. That prevent the lookup from retuning lines with no data.
3)Then afterwards I understand we want the return array back to Xlookup formula
Yes, that is the new array to be searched.