I am having issues creating a formula that will give me a set value based on multiple criteria.
Example:
If Col A="yes"
AND if Col B="No"
AND if Col C= "2"
AND if Col D= "B"
AND if Col E= "X"
Then "Col F"
if not "0"

I am putting together a multiple sheet workbook that is used as a template to submit to the Medicare. I am currently having to manually look up and enter all information for each discipline. What I want is for a cell to look on another worksheet search data in 5 or 6 columns and if they all match the specific criteria asked for it returns the value listed.

The data worksheet contains about 1500 lines and 30 columns total...I only need to use a specific few columns, but every line.

We have tried mutiple/nested if statements and and statements (although not sure I am doing them right) and always get an error about too many criteria.

Any help would be appreciated, thanks!