Home |
Search |
Today's Posts |
#1
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
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linking data between sheet | Excel Discussion (Misc queries) | |||
Linking data from a new sheet (semi-)automatically | Excel Discussion (Misc queries) | |||
linking pivot table data to a cell in other sheet | Excel Worksheet Functions | |||
If data is on one sheet, linking to another | New Users to Excel | |||
Linking Data from 1 sheet to another sheet | Excel Worksheet Functions |