• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Can you use two formulas in one cell

B

brianaclark1967

Member
Hi all,

I've attached a sheet showing the two formulas I want to add together.

The first formula is searching an external sheet (and works fine), but I wanted to add a second formula, that will search the sheet that the result cell is on.

Is it possible at all.

Kind regards

Brian
 

Attachments

brianaclark1967 said:
Hi all,

I've attached a sheet showing the two formulas I want to add together.

The first formula is searching an external sheet (and works fine), but I wanted to add a second formula, that will search the sheet that the result cell is on.

Is it possible at all.

Kind regards

Brian
Click to expand...
Attached sample file with data then only our excel lovers will try this.
You may get answer.
 
Hi Brian,
We need complete information before proceed to give you solution.

What is the ADDRESS of your 1st Formula ?
What are the OUTPUTS of your 1st Formula ?

Regards,
 
Stab in the Dark (keeping in view your previous thread) :

=IFERROR(IF(INDEX(Transport!G82:G3481,MATCH(Deliveries!A:A,Transport!E82:E3481,0))="Beacon",E3861,IF(INDEX(Transport!G82:G3481,MATCH(Deliveries!A:A,Transport!E82:E3481,0))="Lowes",R3861,IF(INDEX(Transport!G82:G3481,MATCH(Deliveries!A:A,Transport!E82:E3481,0))="Palletways",AC3861,""))),20)
 
Hi Khalid,

I've attached a sample sheet in an attempt to explain.

The Deliveries tab/sheet searches the transport tab/sheet for the ref. no. shown.

If found in Transport, it pulls the relevant cost through.

The formula then, hopefully; will pull through the relevant cell when the keyword is entered.

Hope this helps.

I'd upload the whole file but it's too large

Regards

Brian
 

Attachments

Hi Brian,
40 in H6 = OK
69 in H7 = ?? (i think it should be 108)
52 in H8 = ?? (i think it should be 33)

I dont understand the logic of values in these 2 cells.
Or I am still not getting anything?

Regards,
 

Attachments

Hi Brian ,

Try this :

=IF(ISNA(MATCH(Deliveries!C:C,Transport!B:B,0)),IF(ISNA(HLOOKUP(G6,$N$3:$P$17,ROW()-ROW($N$3:$P$3)+1,FALSE)),20,HLOOKUP(G6,$N$3:$P$17,ROW()-ROW($N$3:$P$3)+1,FALSE)),INDEX(Transport!D:D,MATCH(Deliveries!C:C,Transport!B:B,0)))

Narayan
 
You must log in or register to reply here.
Back
Top