• 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 i create a sumifs type formula that will pull in text

J

jonnieRC

New Member
Hi,

I am looking to use a formula that will pull "text" into a main sheet based on criteria in a column and a row (from other tabs). Something like a SUMIFS but that will pull text based on a vertical & horizontal criteria!

Any help would be appreciated.

Thanks,
John
 
Sorry ya, i prob wasn't very clear. I have attached a template which might help explain what i am trying to do.

In the "Input" tab i am trying to consolidate all the information form all the green tabs. I was hoping to do it in a way that, should the green templates change slightly (additional rows for example) that it would be pulled into the Input tab which will drive the pivot table.

I had used an =IF(ISBLANK.......) to bring in the data but it is very manual and not responsive to changes in the templates.

Hopefully that makes sense!
 

Attachments

It's difficult to make it completely flexible, but as long as the header rows are always in row 7 on the green tabs and the codes are always in column A, you could use something like this:

=INDEX(SafeDelivery!$A:$R,MATCH($B8,SafeDelivery!$A:$A,0),MATCH(C$7,SafeDelivery!$7:$7,0))
 
Thanks for that help, i am not sure if i can drag that formula down and across to pick up everything but i can play with it to get it to work. Thanks again :)
 
You must log in or register to reply here.
Back
Top