Update the below table using data from data tab1. The data should change dynamically when the date range is changed

General Excel Questions & Answers

3 Posts

3 Users

0 Reactions

65 Views

RSS

Arun Roger

(@arun-roger)

Posts: 1

New Member

Topic starter

Hi All,

Can anyone provide me the solution or the Exact formula or functions to get the output for the below question? (For Excell 2010 & 2016 - version)

Problem: Update the below table using data from data tab1. The data should change dynamically when the date range is changed

Regards

Arun G

Posted : 22/11/2022 5:34 am

Philip Treacy

(@philipt)

Posts: 1629

Member Admin

Hi Arun,

Sorry we don't do homework/assignments for people. We encourage you to learn to solve the problems yourself.

Looks like you'll need to use a lookup, maybe VLOOKUP or XLOOKUP.

Give it a go and if you get stuck, post back and we'll see if we can steer you in the right direction.

regards

Phil

Posted : 22/11/2022 10:50 pm

Velouria

(@debaser)

Posts: 836

Member Moderator

Posted : 23/11/2022 5:22 am

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed