caroline.vanbommel
New Member
- Joined
- Aug 21, 2006
- Messages
- 27
Hi,
I have a HLOOKUP formula eg.
=HLOOKUP(B4,'[anotherfile.xls]Sheet1'$B$2:$BO$220,219,FALSE
B4 is an sub account of A2
I want the 219 to be replaced the following formula,
=MATCH(A2,'[anotherfile.xls]Sheet1!$B$2:$B$250,FALSE)
A2 is an account name
the point of this formula is that this account name row location changes from sheet to sheet and i dont want to manually fill it in each time over and over.
Does anyone know how to properly combine these two formulas in one?
I have a HLOOKUP formula eg.
=HLOOKUP(B4,'[anotherfile.xls]Sheet1'$B$2:$BO$220,219,FALSE
B4 is an sub account of A2
I want the 219 to be replaced the following formula,
=MATCH(A2,'[anotherfile.xls]Sheet1!$B$2:$B$250,FALSE)
A2 is an account name
the point of this formula is that this account name row location changes from sheet to sheet and i dont want to manually fill it in each time over and over.
Does anyone know how to properly combine these two formulas in one?