Using MIN formula within VLOOKUP

Hi there,

Thanks in advance for your help. I am creating what is becoming a rather complex workbook and need help!

I have one sheet which contains all raw data. A3-A1002 contains names and then B3:ZZ1002 contains corresponding information. I then have a second sheet which contains a summary sheet. There is a drop down in A1 of the summary, from which you select the person the form is for from A:A in Raw Data, and when selected, each cell in the form is populated using the corresponding information from B:ZZ in the Raw Data sheet for that particular person.

One of these form fields, I require the earliest date from columns BL:BV (64-74) however I am struggling to get a positive result with my formula (returns #VALUE!)

=IFERROR(IF(VLOOKUP($A$1,'Raw Data'!A:ZZ,MIN(64:74),FALSE)="","",VLOOKUP($A$1,'Raw Data'!A:ZZ,MIN(64:74),FALSE)),"")

So to recap, A1 is the name of the person to be looking up in Raw Data and then I want to return the earliest date contained within the corresponding row's BL:BV fields.

All help is appreciated!

Hi
Can you upload a sample and small Excel file?

Hi Jose

Thanks for your help with this. I have attached an empty copy of the workbook that I am working on. The first sheet is the form and sheet 2 is my raw data.

I appreciate your help!

Try these formula

Formula:

Please Login or Register  to view this content.

Slight correction

=MAX(OFFSET('Raw Data'!$BL$2:$BV$2,MATCH(QF.AD.23!A1,'Raw Data'!A:A,0)-1,0))

Originally Posted by JohnTopley

Slight correction

=MAX(OFFSET('Raw Data'!$BL$2:$BV$2,MATCH(QF.AD.23!A1,'Raw Data'!A:A,0)-1,0))

Are you sure? The row data has two rows as labels.