My daughter and son-in-law are paying rent to her father-in-law for their home which is owned by them and 2 other family members.
They are living in the home and paying rent.
They are starting to spend money on remodeling and updating the home.
I’m trying to show them how their percentage of...
Thank you very much. I have another wierd issue. When I try to do a simple formula to only show the contents of another cell the formula shows up instead of the other cells contents.
A1 = Capri
Cell P4 - I type =A1 and =A1 shows up instead of Capri. P4 is actually 3 merged cells, if that matters.
I am using this formula to look up a data range in a different tab than the location of this formula and get a reference error.
=VLOOKUP(E53,HERS!,3,A1:C23)
E53 is my input cell data Ie "Brentwood"
HERS is the location (name of the tab) in my spreadsheet
3 is the column I need the value...