Announcement

Collapse
No announcement yet.

Populate Data From Another Sheet With Criteria

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Populate Data From Another Sheet With Criteria



    Hi,

    I hope the thread title is correct.

    I have a spreadsheet which I need to populate the data from sheet based on current date.

    Cell C7 in the "Staff" tab needs to update from tab "Data" for John based on the current date . The current date is located in cell A3 in the "Staff" tab.

    On daily basis, as I open the spreadsheet , cell C7 should update from the "Data" tab automatically based on the date in cell A3 in the "Staff" tab.

    Example, on January 4 2008, cell C7 should populate as 2 from the "Data" tab.

    I tried using the IF formula, but I cant expand the formula for the whole month of January since it is limited only to 7 arguments.

    Appreciate help.
    Attached Files

  • #2
    Re: Populate Data From Another Sheet With Criteria

    in C7 on sheet staff :
    =VLOOKUP(A7;Data!$A$3:$W$6;MATCH(Staff!$A$3;Data!$A$2:$W$2);FALSE)
    In formulae, depending on your locale, you might have to replace ; with , or vice versa.

    Comment


    • #3


      Re: Populate Data From Another Sheet With Criteria

      Thank you ! That worked.

      Comment

      Working...
      X