| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statement linking data from one sheet to another
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 | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If statement linking data from one sheet to another | Excel Worksheet Functions | |||
| linking data between sheet | Excel Discussion (Misc queries) | |||
| Linking data from a new sheet (semi-)automatically | Excel Discussion (Misc queries) | |||
| If data is on one sheet, linking to another | New Users to Excel | |||
| Linking Data from 1 sheet to another sheet | Excel Worksheet Functions | |||
Threaded Mode
