I am doing financial modelling and require to do a VLOOKUP to an area and get a match to a locoation. This location has a date in another column that is in the array area. I am able to do this but once it has found all the matching locations I then wish it to populate the cell with the earliest lcation date and I do not know how to do this after I have asked it to look for the location.
So say the area is C1:H13 and the location is in B100 The location is in C column and dates in H column. I do =IF(ISERROR(VLOOKUP(B100,C1:H13,1,FALSE)),"",VLOOKUP(B100,C1:H13,2,FALSE)). This would give me a date if there was only one matching location but as there is more than one matching location I require the earliest date ie Aug 15 if that was the earliest so what is the next command?
Any help would be greatly apprecaited.
So say the area is C1:H13 and the location is in B100 The location is in C column and dates in H column. I do =IF(ISERROR(VLOOKUP(B100,C1:H13,1,FALSE)),"",VLOOKUP(B100,C1:H13,2,FALSE)). This would give me a date if there was only one matching location but as there is more than one matching location I require the earliest date ie Aug 15 if that was the earliest so what is the next command?
Any help would be greatly apprecaited.