Hello. How can I have this formula dynamically changed based on teh value in another cell? ='15 BUDGET summary'!G150*1000
I want the G from G150 to change, based on the letter in another cell. So if the cell has A then ='15 BUDGET summary'!A150*1000
Thanks.
yes you can but your wording is confusing
i cant tell if you want the formula based on where the cell is or what the value of another cell is
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Hi,
Formula:
Please Login or Register to view this content.
where A1 contains is the reference letter
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks