Multiple IF / OR Statements?

Question

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

mtarler · Accepted Answer

Sue_G&nbsp; 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)

Forum Discussion

Multiple IF / OR Statements?

Share

Resources