Thread
:
Lookup with multiple criteria
View Single Post
#
2
Posted to microsoft.public.excel.misc
Chris Bode[_8_]
external usenet poster
Posts: 1
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
Reply With Quote
Chris Bode[_8_]
View Public Profile
Find all posts by Chris Bode[_8_]