If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
If statement linking data from one sheet to another
Jacob: Thanks for the help, but it didn't work I get the #Ref error.
"Jacob Skaria" wrote: Try =IF(I530,INDIRECT("'+Agency Reallocation data'!D" & I53),"") -- Jacob (MVP - Excel) "Mathew" wrote: I have a spreadsheet with many tabs. I am trying to develop a summery sheet that will ‘auto fill’ certain rows of data and still remain dynamic. What I am doing: in Column I, I have a number; I want this to be the row number for finding the data in the other worksheet. I have If Statements in Columns A thru E for filling the data if Column I has a number in it. If Column I is empty then nothing appears. Formula is: =IF(I53 "","=+Agency Reallocation data!D&I53","") But, when I use this formula I get =+Agency Reallocation data!D&I53 Can someone help me make the formula work so that when Column has a positive integer in it the formula will get the correct data. Thanks for your time! |
#2
|
|||
|
|||
If statement linking data from one sheet to another
Check out your sheet name. Do you have a "+" in front?
-- Jacob (MVP - Excel) "Mathew" wrote: Jacob: Thanks for the help, but it didn't work I get the #Ref error. "Jacob Skaria" wrote: Try =IF(I530,INDIRECT("'+Agency Reallocation data'!D" & I53),"") -- Jacob (MVP - Excel) "Mathew" wrote: I have a spreadsheet with many tabs. I am trying to develop a summery sheet that will ‘auto fill’ certain rows of data and still remain dynamic. What I am doing: in Column I, I have a number; I want this to be the row number for finding the data in the other worksheet. I have If Statements in Columns A thru E for filling the data if Column I has a number in it. If Column I is empty then nothing appears. Formula is: =IF(I53 "","=+Agency Reallocation data!D&I53","") But, when I use this formula I get =+Agency Reallocation data!D&I53 Can someone help me make the formula work so that when Column has a positive integer in it the formula will get the correct data. Thanks for your time! |
Thread Tools | |
Display Modes | |
|
|