• 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.

Formula question

P

Paul McKoy

New Member
Hi Im Paul from Australia. I need help with arrays and copying formulas (I think) working on a massive spreadsheet which requires pulling out rows of data which meet a particular criteria. I created a file which seems to work ok however when I copy to a new spread sheet it does not work (the cells do not show a result however when you put the curser on the cell you can see that there is a formula entered) and I'm not sure why - I have uploaded a copy of the file which does not work. I would be grateful for any help that anyone can provide.

====
Moved by Mod from Introduce yourself thread
 

Attachments

Last edited by a moderator:
Paul McKoy said:
Hi Im Paul from Australia. I need help with arrays and copying formulas (I think) working on a massive spreadsheet which requires pulling out rows of data which meet a particular criteria. I created a file which seems to work ok however when I copy to a new spread sheet it does not work (the cells do not show a result however when you put the curser on the cell you can see that there is a formula entered) and I'm not sure why - I have uploaded a copy of the file which does not work. I would be grateful for any help that anyone can provide.

====
Moved by Mod from Introduce yourself thread
Click to expand...
its a tricky 1???need to see paul:)
 
Paul,

Welcome to the forum. You haven't described what your actual problem is very well, so we're having to guess a bit. Looking at the 4027 sheet, there are several formulas in place which do a VLOOKUP to the other sheet, 'Master Data Word List'. If you try to copy just this one sheet to a different workbook, you would need to eihter paste as values, or copy both sheets at the same time, and make sure that the VLOOKUP formulas are looking at the sheet within the same workbook, and not trying to look externally (a different workbook).

If you can better describe the problem, we may be able to provide a better solution.
 
Hi jayalaxmi thanks for having a look. The file has no VBA only has formulas that I put together from pulling info from other sources before I came across chandoo.org.

Essentially what I need to do is pull out all the items of similar type and their corresponding values in the rows and then out put a sum for each type.

In my worksheet I created a table to pull out rows with a particular word type, I will have 1 table for each word type (the portion of the sheet attached only shows two tables) below this table I have another table in which I pull together all the results from the other tables which I used to pull out the rows. The table I am having problems with is L5:T228 the formula entered in cell L5 is {=IFERROR(INDEX(B$4:B$1247,SMALL(IF($I$4:$I$1247=$M$2,ROW(B$4:B$1247)-ROW(B$4)+1),ROWS(B3:B$4))),"")} the formulas in the other cells are the same as if dragged from L5. The formula works well in the original spreadsheet I prepared but does not work when the sheet or the formula is copied to a new location.
 
Luke M said:
Paul,

Welcome to the forum. You haven't described what your actual problem is very well, so we're having to guess a bit. Looking at the 4027 sheet, there are several formulas in place which do a VLOOKUP to the other sheet, 'Master Data Word List'. If you try to copy just this one sheet to a different workbook, you would need to eihter paste as values, or copy both sheets at the same time, and make sure that the VLOOKUP formulas are looking at the sheet within the same workbook, and not trying to look externally (a different workbook).

If you can better describe the problem, we may be able to provide a better solution.
Click to expand...
Thanks Luke,
I hope my response to jayalaxmi gives a bit more info - also the Vlook up works fine - for some reason the I am having problems with the formula in L5:T228.
 
You must log in or register to reply here.
Back
Top