If function formula Returning value from different sheet based on text in Cell

Hi guys

been a massive help so far.

I have one last challenge (for the time being)

Ive populated what will in essence be a dashboard.

and if something is at risk - then there is a figure that would be lost.

I have the figures on another sheet, but I only want the cell in sheet 1 to populate the figure from sheet 2 if it shows "At risk" if there is no risk then I would want the cell to return a "0"

I'm just unsure how to build the formula

You can use this formula in C3 of Sheet1:

=IF(B3="At Risk",VLOOKUP($A3,Sheet2!$A:$B,2,0),"")

Copy down to the bottom of your categories, then highlight those cells and copy/paste into E3, G3 and I3.

Hope this helps.

Pete

huge help Thank you!!!

You're welcome, and thanks for marking the thread as Solved.

As you are relatively new to the forum, you might also like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete