View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Chris Bode[_8_] Chris Bode[_8_] is offline
external usenet poster
 
Posts: 1
Default Lookup with multiple criteria


Well, you can create a formula in such a condition using just the if –
else statement as
=if(a=x,if(b=y,if(c=z,C1)))


Chris
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com




--
Chris Bode