Forum Discussion

Tim Mullady's avatar
Tim Mullady
Copper Contributor
Jul 25, 2018

function help

I'm using the following formula and wanted to see if someone could help me tweak it a bit.   IFERROR(IF(VLOOKUP(C:C,SUMMIT!B:J,9,FALSE)+1<A2+1,"REGISTERED","NOT REGISTERED"),"NOT REGISTERED")   C...
Excel Desktop
Formulas & Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jul 25, 2018

Hi Tim,

 

VLOOKUP returns first found record, if your SUMMIT data is in chronological order that means the earliest registration.

And your formula could be

=IFERROR(IF(VLOOKUP(C2,SUMMIT!B:J,9,FALSE)<A2,"REGISTERED","NOT REGISTERED"),"NOT REGISTERED")

Or that's not a case?

Resources