Hello! Is there a way for the cell containing the xlookup formula to remain editable if no match is found? For instance, I have set up my spreadsheet so that xlookup fills in a corresponding price if a certain item is selected from the drop-down. However, sometimes a "one-off" item is entered which I've allowed as an "invalid" entry. Is it possible to edit the "price" cell as one would normally instead of being blocked by an error message in these unique cases?
Hey there, thanks for the question. It can't be done the way you described it. If you can, try using the not found message as described here: sheetshelp.com/xlookup/#Example_2_8211_Using_a_Not-Found_Message
can I somehow use two values for the key? For example: I have a table like in your example at 2:36, but I have two different people named Jim, one from South and one from North. I want to lookup for both their specialities by entering the name and region. How can I accomplish this?
Consider using the FILTER function instead. I made a video about comparing the two on my Prolific Oaktree channel. See if this helps: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-zFo9H0Uw4i8.html
The feature was released August 24 and is being rolled out over 15 days. Therefore, it makes sense that you might not have it yet. You’ll have it soon though.