asked on

nested If/and formula needed

I need two nested formulas. Spreadsheet attached.
The first formula will look IF "Budgeted" then will look at the dollar amounts per attached file. Then depending on the dollar amounts, will return COO, CFO, CFO etc.

The next formula will look at IF("Unbudgeted") and dollar amounts and will return the associated COO, CFO etc.

Thanks for the help!
formula-needed-two.xlsx

Wayne Taylor (webtubbs)

Can you describe in more detail what it is you want to achieve, with the end results shown in your attached workbook?

vpopper

ASKER

I wasn't sure how to upload a new file to this question so I created a new related questions that has a modified file that shows the criteria.

Thanks

Ryan Chong

your attached file is not really a good template since the cell values for budgeted amounts are not in numeric. Hence, you need to change the cells into numerical values and you probably need some IF and VLOOKUP functions in your formula.

=IF(B27="","",IF(B27="Budgeted", VLOOKUP(C27,D$16:E$19,2), VLOOKUP(C27,D$21:E$24,2)))

Open in new window

see attached for more info.
formula-needed-two_b.xlsx

ASKER CERTIFIED SOLUTION

Shums Faruk

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

vpopper

ASKER

Perfect!!! Thank you.

Shums Faruk

If your problem is solved, I would request you to please close the question accepting which solution helped you.

Shums Faruk

Author acknowledge solution worked for him/her. It should be closed appropriately instead closing.

Ryan Chong

@vpopper

pls advise which comments are useful in helping you to find the solution. you may awards points to those comments instead.

vpopper

ASKER

did not realize that I didn't close this question. Shum's solution worked perfect.

Shums Faruk

You're Welcome! Glad I was able to help