DebtAcquisitions
New Member
- Joined
- May 20, 2015
- Messages
- 21
I have a cell that looks up an account number and returns what row it is in. (B2)
but, the data I am looking for is below and a few columns over, so I need to use an offset command to get the data.
=OFFSET(data!F22,1,0)
this works just fine. the problem is that I need to copy this command down for about 90,000 rows and the "F22" part of that needs to be changed based on the row that the account is found (B2=22) In this case.
I want to concatenate the offset command to get the 22 value, but I cant get the command to work. this is what I have.
=OFFSET(CONCATENATE("data!","f",B4,),1,0)
the command looks right, but its just not working... any ideas??
but, the data I am looking for is below and a few columns over, so I need to use an offset command to get the data.
=OFFSET(data!F22,1,0)
this works just fine. the problem is that I need to copy this command down for about 90,000 rows and the "F22" part of that needs to be changed based on the row that the account is found (B2=22) In this case.
I want to concatenate the offset command to get the 22 value, but I cant get the command to work. this is what I have.
=OFFSET(CONCATENATE("data!","f",B4,),1,0)
the command looks right, but its just not working... any ideas??