Populate cells base on input table

[Abdmujib]

I want to input data in the input table (column G, H, I) and makes it populate in column C.

Column B is the depth in meters, when data is imputed in input data the geology would be filled for depth value from the start, and ends inthe depth end value indicated.
ease
i needed a formular to work it out please

 

[hagia_sofia]

Hello, try this:

=FILTER($I$5:$I$7,($G$5:$G$7<=B3)*($H$5:$H$7>=B3))

 

[kvsrinivasamurthy]

In G4

=LET(a,B3:B13,b,C3:C13,c,UNIQUE(b),d,MATCH(c,b,0),e,INDEX(a,d),f,INDEX(a,d+COUNTIF(b,c)-1),HSTACK(e,f,c))

 

[Abdmujib]

Hello, try this:

=FILTER($I$5:$I$7,($G$5:$G$7<=B3)*($H$5:$H$7>=B3))

I'm so sorry, I am working on excel 2016

 

[Abdmujib]

In G4

=LET(a,B3:B13,b,C3:C13,c,UNIQUE(b),d,MATCH(c,b,0),e,INDEX(a,d),f,INDEX(a,d+COUNTIF(b,c)-1),HSTACK(e,f,c))

I'm so sorry, I forgot to indicate that I am working on excel 2016

 

[Fluff]

How about

=INDEX($I$4:$I$10,MATCH(B3,$G$4:$G$10,1))

 

[kvsrinivasamurthy]

In C3

=INDEX($I$4:$I$10,MATCH(B3:B13,$G$4:$G$10,1))

 

[Fluff]

Why B3:B13, that is not going to Spill with 2016.

 

[kvsrinivasamurthy]

Abdmujib's version is 365​

 

[Fluff]

See posts 5 & 6.