albertof91
New Member
- Joined
- Jul 12, 2022
- Messages
- 5
- Office Version
- 2019
- Platform
- Windows
Is there any formula to search for a cell in a different sheet with a specific text? But I need that the result of the formula is the cell number of that text. So I can use this "cell number" for a different formula.
Let's say I have in sheet 2 the cell C5 with the text "quantity", but in sheet 1 I would require to obtain this "C5" so I can use it within ADDRESS formula or ROWS/COLUMNS.
In sheet 3 I would have the same text "quantity" but in a different cell, let's say D6, therefore depending on the sheet the formula ADRESS would be changing.
Thanks!
Let's say I have in sheet 2 the cell C5 with the text "quantity", but in sheet 1 I would require to obtain this "C5" so I can use it within ADDRESS formula or ROWS/COLUMNS.
In sheet 3 I would have the same text "quantity" but in a different cell, let's say D6, therefore depending on the sheet the formula ADRESS would be changing.
Thanks!