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

 

[kvsrinivasamurthy]

Sorry . I saw only Post#1.

 

[Abdmujib]

How about

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

Thank you so much sir, it works.

 

[Abdmujib]

Thank

In C3

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

Thank you so much it works, but I am working with my office PC not my own, so it 2016 version. The spill didn't work on it but it works perfectly on my 365

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Abdmujib]

Glad we could help & thanks for the feedback.

Sorry for asking this in this section, let asumed in the picture I sent earlier, instead of writing the Geology input like, top soil, coarse sand. The cell is blank, but has a different pattern style. is it posible for excel to return the pattern style foe Column C. Something like this picture sir

 

[Fluff]

No it's not. A formula cannot "see" cell formatting. You would need to use VBA.

 

[Abdmujib]

O

No it's not. A formula cannot "see" cell formatting. You would need to use VBA.

Okay sir, Thank you so much sir.

 

[kvsrinivasamurthy]

Thank

Thank you so much it works, but I am working with my office PC not my own, so it 2016 version. The spill didn't work on it but it works perfectly on my 365

Thanks for feedback.