SOLVED

Joining a Formula into another Formula

Contributor
I have attached my table below, in cell F5 I have made a formula =E5-D5. In cell M5 I need a formula that well look down column B and find cell with FSG and then look across row 3 and find the cell that also has FSG ( I can do an individual search like =IF(B5=F3,"True") what I'd like to do is a formula that will e.g B5=F3 so if that's true shown me the figure I have in cell F5 (rembering cell F5 is a formated cell).
1 Reply
best response confirmed by Norman_Glenn (Contributor)
Solution

@Norman_Glenn 

Maybe as in the attached file.