Forum Discussion
Formula Help Please: combining IF AND and IS
I have a list of people with a two characteristics (Category of client and type of Service) in columns A and B and a separate table of prices on a different tab. I want a formula to automatically...
You may use INDEX/MATCH, concrete formula depends on how is you table with prices structured (e.g. three columns Cat, Service, Price, or Service is in the top row as header, etc)
Exactly that. The headers are Category, Service and Price
For data like this
the formula could be
=IFERROR(INDEX($H$2:$H$7,MATCH(1,INDEX(($B2=$F$2:$F$7)*($C2=$G$2:$G$7),0),0)), "no price")
and in attached file