|
| 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
May 27th, 2010, 08:53 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
May 27th, 2010, 09:44 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 | |
|
|
Linear Mode
