Forum Discussion
Solved
Excel Lookup function with varying criteria
Hi,
Firstly I will apologise for what I am sure is a simple request.
I am trying to create a VLOOKUP function to generate a geology type for a certain depth within a certain location ("HOLE ...
As variant that could be array (Ctrl+Shift+Enter) formula
=INDEX($D$3:$D$14,MATCH(1,(H14>=$B$3:$B$14)*(H14<$C$3:$C$14)*($G14=$A$3:$A$14),0))
please see attached
Hi Sergei,
Yes sample depth must be between Depth top and Depth base.
I.e. Cell H3 (referring to BH1001 at 1.5m depth) should output "Alluvium".
Thanks,
Oliver
As variant that could be array (Ctrl+Shift+Enter) formula
=INDEX($D$3:$D$14,MATCH(1,(H14>=$B$3:$B$14)*(H14<$C$3:$C$14)*($G14=$A$3:$A$14),0))
please see attached
Sergei,
That's brilliant, all three solutions work perfectly. Many thanks for your help! The examples will go straight in my technical library.
Best,
Oliver