Multiple IF / OR Statements?

[Sue_G]

Hello!

I have a sheet where I'd like to fill in data, based on the data range from 2 other series of cells.  I have attached a copy of the file for your review.  In cell C9, I'd like to fill in the data from column H, where Column G has a number >0.  The values in column G will have numbers greater than 0 only one at a time (so if there is a number >0  in Cell G4, cells G4-G9 will always be 0, if there is a number >0 in cell G7, cells G4-G6 and cells G8-G9 will be 0, etc.).   

[#2 · Accepted solution]

@Sue_G  You can use:

=XLOOKUP(1,G4:G9,H4:H9,"",1)

but if you have older version of Excel w/o XLOOKUP you can use:

=VLOOKUP(MAX(G4:G9),G4:H9,2,FALSE)

[#3]

Thank you! It works perfectly!