Forum Discussion
Solved
Auto Fill Cells by typing first 3 chars with Formulas that will work on Excel tablet version?
Hey all, I'm in a bit of a pickle. I have built out a crazy excel workbook with several sheets on a tablet version of Excel. (I dont currently own a pc, no vba possible?). All I need is one f...
- I figured it out by using chatgpt, (finally), for anyone who comes searching for it in the future here's the formula:
=IFERROR(INDEX($A$144:$A$204, MATCH($B27, $B$144:$B$204, 0)), "")
I'm typing things into B27, which have to be an exact match with cells $B$144:$B$204, and then it returns the adjacent row ($A$144:$A$204) if there's a match.
Thanks. But I'm on the tablet version of excel, I don't have any "data validation" or "list" buttons up top. I had already tried asking chatgpt and it gave me similiar responses. In my case, it has to be basic formulas that the tablet version can use, no data validation or list commands are available on this tablet version unfortunately.
【移动端树形选择复制-哔哩哔哩】 https://b23.tv/8GfJ2PZ
I am using web to search and pick data to excel on Android device.
I am using web to search and pick data to excel on Android device.