• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Combining Formula to look up in different excel tab

K

keanur

Member
Hi Excel Ninjas,

recently i work on excel template, and there is a challenge when i want to use a proper formula for the specific column (Total Sell Revenue) in Pick Up Report Tab. basically, what i want to do is a simple formula that can look up at Total sell revenue on Database Tab. However it will change whenever I update the total sell revenue on Actual Tab. We received final number coming from finance and we use it as the actual figures. Hopefully my explanation is clear enough. Could you assist me on how excel can do this. Attached is the sample report. Thanking you for your friendly assistant.

Regards,

keanur
 

Attachments

  • TEST report.xls
    185.5 KB · Views: 8
In "Pick up report"!P11: =IF(ACTUAL!D3=0,VLOOKUP(B11,DATABASE!$B$4:$H$31,7,0),ACTUAL!D3)
Copy down
 
You must log in or register to reply here.
Back
Top