Index If?

DBody · 01/09/19

Hi. I'm trying to retrieve a cell value from one sheet to another where it looks up the ID# and retrieves the Score. However, I want it to retrieve the most recent Score, because the sheet it is retrieving from is a historical record with many different scores assigned to that ID# over time. Could someone help me with the formula? Thanks!

Andrée Starå · 01/10/19

Hi,

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, andree@getdone.se)

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome · 01/10/19

What is your current formula? It may be something as easy as adding in a MAX function referencing your dates.

Index If?

Comments

Help Article Resources

Categories