- Registration date
- Sunday September 12, 2010
- Last seen
- June 8, 2021
I think you are looking for the VLOOKUP formula.
Let's say you are looking for the word "closing balance" on sheet 4 and place the value next to it, in a cell on sheet 5. "closing balance is located somewhere in column A.
Select your cell in sheet 5 and try the following formula there: