Forum Discussion
Combining VLookup, max and other formulas to find customer's most recent visit - guidance?
Hello! Looking for some help with a formula - attaching an example spreadsheet with some simple data. My data are in two tabs - it needs to stay that way. On the second tab, I would like a formula th...
=INDEX('Raw Visit Data'!$C$3:$C$17,MATCH(LARGE(IF(('Raw Visit Data'!$B$3:$B$17='Needed Output'!B3)*(NOT(ISBLANK('Raw Visit Data'!$D$3:$D$17))),'Raw Visit Data'!$D$3:$D$17),1),IF(('Raw Visit Data'!$B$3:$B$17='Needed Output'!B3)*(NOT(ISBLANK('Raw Visit Data'!$D$3:$D$17))),'Raw Visit Data'!$D$3:$D$17),0))
You can try this formula which works with e.g. Excel 2013 as well. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel for the web or Excel 2021.
- OliverScheurich - thank you! This works perfectly! I'm not sure which method I like better - yours or Harun24HR. Harun's formula is a bit shorter.
