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.
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.
=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.