Is there an IF statment equivalent to SumIFS?

%3CLINGO-SUB%20id%3D%22lingo-sub-321129%22%20slang%3D%22en-US%22%3EIs%20there%20an%20IF%20statment%20equivalent%20to%20SumIFS%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-321129%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20spreadsheet%20with%20a%20tab%20that%20has%20my%20data%20in%20a%20database%20format.%20%26nbsp%3B%26nbsp%3B%20I%20need%20to%20write%20an%20if%20statement%20that%20will%20search%20a%20column%20of%20data%20and%20return%20a%20value%20from%20a%20different%20cell%20within%20the%20same%20record%20line.%26nbsp%3B%20(Search%20a%20list%20of%20products%20and%20return%20the%20price)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20used%20the%20Countifs%20and%26nbsp%3B%20Sumifs%20formulas%20in%20the%20same%20database%20and%20am%20receiving%20good%20totals.%20%26nbsp%3B%26nbsp%3Bhowever%20I%20don't%20see%20an%20equivalent%20for%20IF%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-321129%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-321224%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20an%20IF%20statment%20equivalent%20to%20SumIFS%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-321224%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you!%20%26nbsp%3B%20I%20didn't%20know%20about%20index%2Fmatch%20%26nbsp%3B%20That%20worked%20very%20well.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-321191%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20an%20IF%20statment%20equivalent%20to%20SumIFS%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-321191%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20may%20use%20INDEX%2FMATCH%20or%20VLOOKUP%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I have a spreadsheet with a tab that has my data in a database format.    I need to write an if statement that will search a column of data and return a value from a different cell within the same record line.  (Search a list of products and return the price)

 

I have used the Countifs and  Sumifs formulas in the same database and am receiving good totals.   however I don't see an equivalent for IF  

2 Replies
Highlighted

You may use INDEX/MATCH or VLOOKUP

Highlighted

Thank you!   I didn't know about index/match   That worked very well.