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 final formula that will automatically fill or copy/paste an existing cell into another cell based on the first 3 characters I type.
For example, if I start typing "ARI" in a specified cell, I would like excel to automatically fetch the ARI cell with the rest of the data after it. Is this possible on a tablet version without vba? I have 2 columns of data, 1 with the full string, and 1 with just the first 3 characters typed out, both side by side if that helps.
Any suggestions?
Thanks !
- 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.
- 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. - how to format a column to text
so i don't know about "Auto Fill" exactly but you can use FILTER to automatically fill in the adjacent cell with the corresponding value. So lets say your 3 letter codes are in A1:A100 and the data are in B1:C100 then you type the 3 letter code in cell E1 and put this in F1:
=FILTER($B$1:$C$100, $A$1:$A$100=E1, "")and BTW you can add 'Data Validation' to cell E1 and set it to be a 'List' and select the range A1:A100 and you can have a drop-down selection for that cell and hopefully auto list filtering will be rolled out soon to make it even nicer.
- 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.
