Hi,
Just like the Excel FIND feature (not the formula, the feature ie CTRL+F) - type in what you want, Excel finds it and highlights the cell.
How do I do this in a formula?
I keep getting results like how to use the FIND formula and how to select cells with formulas in them. Not what I want.
I want :
Pseudo-code : =FINDCELL("testword",0) (zero for case-insensitive, and since I'm making up a function here, why not).
Result = C5, cause cell C5 contains "testword".
Thank you.
PS : The function of such a formula would be to "read" an imported document, find keywords, and then be able to extract relevant information from cells relative to that position.
- Ex
Import #1 "Pt Payments" is found at cell J5, so now I can use that knowing that column J, rows 6+ contain the payment data.
Import #2 "Pt Payments" is found at J8 (cause something above it was taking up space), so now I can use that knowing that column J, rows 9+ contain payment data.
Import #3.....found at L6 for whatever reason, ....
Useful since imports from PDFs etc dont always space equally.
Bookmarks