Thread: Looking at a cell and deciding which formula to use

Hi,

I've ran into a small problem. I'm a novice regarding excel so any help is welcome.

I have a spreadsheet, where I would need to make following:

- look in the row (11 and 12) for the following values: Unkown and Totals:

If Unkown is found then I would need following executed: =VLOOKUP($B11,MPC!$B$2:$D$10,3,FALSE)

If Totals: is found then the following:
=SUM(G4:G11)

Thanks for any help.

Regards,
George

Hi Martin,

Thanks for the quick reply.

I've attached text.xls, I hope I included everything.

In my reports some of the tables will have Unknown and some of them won't. In B9:D12 values are copied over from another workbook. In E9:H12 are formulas which work with these data. But sometimes I will get Unkown and I will have to be able to make a difference in link 11 and 12 to be sure which formula is applied.

Thanks,
George

Any ideas?

Thanks,
G.

Hi Martin,

This helped thanks. Could you please let me know, if there's a formula that would allow me to:

Leave the cells E12:H12 empty if B2 is empty, but if it has value then applying the code provided by you (=if(b11="unknown team",some formula here,normal formula here)

Thanks,
G.

Hi Martin,

Thanks for all your help.

It look like it works

George