Sue_GBrass ContributorJul 26, 2021Multiple IF / OR Statements? 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 t...Show More02-2005 Tryptic Soy Broth (TBS) Test.xlsx36 KBmtarlerJul 26, 2021Sue_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)
mtarlerJul 26, 2021Sue_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)
mtarlerJul 26, 2021Sue_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)
mtarlerSilver ContributorJul 26, 2021Sue_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)
