Vlookup - Referencing Sheet Index
I am trying to find out whether it is possible to reference to a sheet index number, instead of sheet name, in a VLOOKUP formula.
For instance, normally I would write:
VLOOKUP(A1,'ExampleSheet'!A1:B10,2,False)
(I hope got the translation to English language Excel correct)
Let's say that the sheet index of Examplesheet is 2 (at least it is 2 the way VBA sees it).
Is there a way I could reference sheet number 2 in the VLOOKUP formula, instead of its name? My sheet names vary, but the formula should look in the same area, regardless of name.
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
- Nested IF (index And Match): Calculate A Charge In Cell K15 Based On Values In B9 And C10 Referencing The Table I8:R9
- Formulas By Using VLOOKUP, INDEX, MATCH, INDEX&MATCH Separately
- VLOOKUP Cell Referencing #VALUE Error
- Match/index/vlookup
- Vlookup Or Index/match
- Vlookup OR Index And Match.
- Index Vlookup Match
- Combining IF And Either Vlookup Or Index
- VLOOKUP Or INDEX Function?
- Vlookup / Index On 2 Criteria
- VBA To Insert An Index/match Forumla On Sheet 1 To Lookup A Value From Sheet 2
- Referencing A Sheet Name?
- Index, VLOOKUP, MATCH Formula
- Vlookup With Variable Column Index
- Vlookup With More Than Single Column Index
- Referencing Sheet Tabs
- Referencing A Sheet From An Inputbox
- Referencing Another Sheet In Same Workbook
- Referencing Cells In Another Sheet
- Vba Sheet Referencing
- Vlookup With Changing Column Index Numbers
- Vlookup Or Index/match With Most Recent Record
- HLOOKUP VLOOKUP INDEX & MATCH Etc
- Index/match/vlookup And ODBC SQL
- VLOOKUP -- Automatically Change Column Index
- Vlookup, Index, Match, Offset, What Combination Should I Use?
- Formula Referencing Previous Sheet
- Referencing Cells Dependent On Sheet Name
- VLOOKUP And Identifying Column Index With An Input Cell
- Vlookup Or Similar With Variable Col Index Number Value
- VLookup/Index (round-down E3 And Find Its Corresponding Row In The Table To The Right)?
- Referencing Cells From Another Sheet, Dealing With Blanks
- Referencing Active Cell's Value From Another Sheet
- Referencing Sheet Code Names By Variable
- Referencing A Sheet Name Entered In A Cell For Formula
- Conditional Formating IF, Match, Index And Vlookup To Find Several Duplicated Value
- Vlookup, Match, Index: Calculation By Customer, By Service Type
- Multi Sheet Cell Referencing While Skipping Rows
- #REF! Error Referencing Worksheet After Importing Sheet
- Vlookup Referencing Cell With "left" Function
- Referencing Selected Tabs To Print Selection & Update Table Of Contents Sheet
- Sheet Index In Vba
- Get Sheet Index Number
- Create Index Of Sheet Data
- Creating And Naming A New Sheet From An Index
- Popup Menu For Sheet Index
- Change Sheet Index Numbers In VBA?
- Index / Array Return A Value From Same Column In Another Sheet
- VLOOKUP / INDEX / MATCH Function: Match Data From 2 Independent Sets??
- Fastest Lookup Method: Use A Key To Lookup A Value (VLookup, Index/Match, DGet, And The Rest)
Formulas By Using VLOOKUP, INDEX, MATCH, INDEX&MATCH Separately
I have this table .......A.....B.....C....D 1.....I......a.....d.....g 2.....II.....b.....e.....h 3.....III....c.....f......i As you can see, the number I has a,d,and g, II has b,e,and h, and III has c, f, and i I want to make formula that if I make the input g it would return I, f would return III, and c would return III, and so on I want to make four formulas by using VLOOKUP, INDEX, MATCH, INDEX&MATCH separately.
View Replies!
View Related
VLOOKUP Cell Referencing #VALUE Error
I'm working on a spreadsheet for a gaming community. This sheet is used by more than 3000+ players and growing. It has to be updated roughly twice a week for new inventory items, which can range from 1 to 3 new items weekly. To make it easier on new and existing members, I want to create a way to make updates with the spreadsheet easier and to allow players an easier way of updating the spreadsheet rather than re-entering all the data over and over again twice a week. So, I started to use VLOOK in some formulas to look at the data and pull the corresponding information. However, this same information is used throughout the sheet and referencing this information has brought about #VALUE errors that I cannot seem to figure out how to get around. I've included a copy of the spreadsheet to download and review in hopes of finding a solution. Here's what this speadsheet is doing: MyInventory is where the players will enter all their items, with some being drop-down selections and manual entry. The LookupedInventory worksheet is where the VLOOKUP (columns C,G,J,Q,etc.) formula is used to look up entries in the MyInventory worksheet and pull their values over to the LookupedInventory worksheet. Now these values from the LookupedInventory will be carried over into two other worksheets, InventoryTableAttack and InventoryTableDefense. These two worksheets are where my #VALUE errors are appearing. If the cell referenced is empty, the #VALUE error appears. However, if the cell references a number, the rest of the formulas tied to to this cell reference work. However, since there are errors, the rest of the worksheet cannot function until I fix all the #VALUE errors. So, what I'm seeking is to see where my issue is and what I need to do to fix it. If I need to take a different approach to this, please let me know what that is and how to go about doing it. I've even thought about a macros that copies and paste all the current data from an older spreadsheet to the new one, but I'm not that good at macros. If I can stay away from macros, that would be good, but if not, then I'll have to dig in my heels and start leaning.
View Replies!
View Related
Match/index/vlookup
I have two worksheets that I am hoping to use to generate one report in excel. Sheet1 contains the following information for my entire work center: Benefitor Account Dollar Value Document # Sheet2 contains a list of Benefitors that are relevant to only me. I want to pull the information from Sheet1 where the benefitors on Sheet1 match the benefitors listed on Sheet2 into Sheet3.
View Replies!
View Related
Vlookup Or Index/match
I am trying to get the info shown on table 1 into table 2. I suspect index and match is the answer, but I am not sure. Table 1 Employee # Deduction Amount 101 AD&D 7.00 101 LIFE 4.00 101 LTD 12.00 101 STD 6.00 101 HEALTH 300.00 101 DENTAL 25.00 105 AD&D 8.00 105 LIFE 6.00 105 LTD 6.00 105 STD 300.00 105 HEALTH 25.00 105 DENTAL 8.00 112 AD&D 7.00 112 LIFE 5.00 112 LTD 13.00 112 STD 5.00 112 HEALTH 450.00 112 DENTAL 37.00 Table 2 AD&D LIFE LTD STD HEALTH DENTAL 101 105 112
View Replies!
View Related
Vlookup OR Index And Match.
I have a worksheet that has numerical data in A1:A22. In E1:E61 I have set values in numerical order and in F1:F61 I have a letter or letters that correspond to E1:61. I am trying to write a formula in B1 that will look at the value in A1 and then match it up in E1:E61 and then return the corresponding letter in F1:F61. e.g: in A1 i have an INDEX and MATCH formula
View Replies!
View Related
Index Vlookup Match
I have a tab that has Employee Name in one column and the benefit they chose in another column. The employee name is repeated a number of times since they have chosen more than one benefit. I am trying to create a new tab where the employee name in is the first column (only once) and each benefit is listed in separate columns along the top. I want to put an "x" in the column for the benefit the employee has chosen. Is there a way to say "look for this employee, see if this benefit is what they chose, and if it is, put an "x", if not, leave blank"?
View Replies!
View Related
Combining IF And Either Vlookup Or Index
I think I need to combine functions to allow me to automate data entry from a table from another worksheet. If the Name entered in column A on Exp Breakdown matches a name in column A of Salary Breakdown I cannot seem to write a function to scan the table in Salary breakdown and lookup the percentage that person is paid from a specific program number. I have attached a sample worksheet to hopefully make it easier to understand.
View Replies!
View Related
VLOOKUP Or INDEX Function?
I tried with the VLookup, and HLookup and neither one worked for me. I have a reference table with all the data, and then input sheet where I want to bring this data by using one of the excel function. ie. When I enter office name on the top of the input page, I would like the Tax ID # in cell C3 to fill in using the excel function from the data on the reference tab. Same with cell C14 & C15. see attached for an example.
View Replies!
View Related
Vlookup / Index On 2 Criteria
I have tried the Vlookup formula, and also the index/match formules but I can't get my desired outcome. As you can see the setup is fairly simple. For turnover I want to lookup the values based on Period AND profit center This last bit is my problem, how to define a double criterium. The idea is to choose the wanted latest estimate (cell B1) and that for turnover, discount etc the values are based on 2 criteria (periode and profit center) I have also added the desired outcome to clarify my question.
View Replies!
View Related
Index, VLOOKUP, MATCH Formula
I have the following arrangement PVCu_Woodgrain_DoorF190210300#REF! PVCu _woodgrain_Door is a drop down list that selects from a number of named ranges. The Cell that shows (F1) and is called DOORSTYLE with 6 choices F1, F2 ... F6 (I cannot change these to numeric only values) 300 is the 2 previous cells added together. It is called DRSZ1 and will match a numeric value in the named array. My formula cell with the issue has this formula; =INDEX(INDIRECT(ARRAYDR1),MATCH(DOORSTYLE,INDEX(INDIRECT(ARRAYDR1),0,1)),MATCH(DRSZ1,INDEX(INDIRECT(ARRAYDR1),1,0))) I know MATCH(DOORSTYLE,INDEX etc. should be a VLOOKUP to find F1 in the named array, but I just cannot get it right.
View Replies!
View Related
Vlookup With Variable Column Index
VLOOKUP($L4,'[mail.xls] new'!$A$6:$AB$261,6,FALSE) Which gives me proper result...but the problem i m facing is i have many columns after L4 like M4, N4, O4 and so on....where i have to get the result. So for that every time i have to paste the above formula and manually change the col_index_num i.e. 6 then 7,8,9 in every column where i use the above vlookup. So is there anyway that it will append the col_num_index by 1....i.e.
View Replies!
View Related
Referencing Sheet Tabs
Is there a way to use the "value" of a name in a drop-down list to reference a sheet tab name in a formula? A1 has a drop down list. When a name (Bob's Sales) is selected from the drop down list, B1 shows the value of cell D5 from sheet "Bob's Sales".
View Replies!
View Related
Referencing A Sheet From An Inputbox
I have a quick question that'll hopefully have a quick answer. Part of my workbook requires an input box to appear. When you type the name of one of the worksheets into the box and hit enter I want a VLOOKUP formula I've written to compare to that worksheet. Heres what I mean, with some descriptions of what i would like:
View Replies!
View Related
Referencing Another Sheet In Same Workbook
I have two sheets in the same work book and I want to pull values through from one to the other. So its a simple =Sheet2!B45 or whatever yeah? But no! What Excel 2007 does when I hit enter is to swap the Sheet!2 bit for "C:documents and Settingsmy documentsspreadsheetsmyworkbook!Sheet2!B45" or some such. Why the hell does it do that and how can I stop it.
View Replies!
View Related
Referencing Cells In Another Sheet
I need assistance referencing cells in other sheets. I have a summary tab which I would have each refenced sheet listed (named for the activity being billed). In a separate cell in the summary tab, I want to bring back the value of the total amount billed for that activity. The total value is in the same cell of each sheet, as all invoice tabs needing to be referenced are identical in layout. There is one hitch to this, the sheets referenced have not yet been created (that would be too too easy), and the activity list in the summary sheet has place holder names that will change when the activity being billed is defined (hence prompting the biller to create the sheet to be referenced).
View Replies!
View Related
Vba Sheet Referencing
I have 8 sheets, named cpt1 to cpt8 in vba. Now i need to loop through these 8 sheets, storing the same range of each sheet into a matrix. I have the following dim test () as variant For i = 1 to 8 (1) test = sheets(i).Range("b2:u21") (2) test = cpt1.Range("b2:u21") next i Now (1) doesn't work, but (2) does. However i do not know how to reference the cpt1 sheet name using the for loop (ie "cpt" & i) Can anyone help me with getting this to work?
View Replies!
View Related
Vlookup With Changing Column Index Numbers
I've 2 worksheets, Summary and Sales. I need to get the total sales figure from the "Sales" worksheet onto the Summary worksheet. Sales data are pasted onto the worksheet monthly. Tried using vlookup but problem is, the column containing the total sales figure may vary and I need to update the vlookup formula. Another problem is that sometimes the Total sales (the lookup value) is not in the first column. Tried using the Index and Match combo but cannot get it to work. I've attached a simple mock up to hopefully illustrate my case better. I believe the experts in this forum should find this rather easy!
View Replies!
View Related
HLOOKUP VLOOKUP INDEX & MATCH Etc
I don't want VB code but a worksheet formula. I have a table full of names and cars sold. The table tracks the person's progress. It is like a diary. It's a simplied version of the DB I am currently working with. Is it possible to do the following things? I have basically 2 types of questions. 1)When was the last red car sold? 2)When was a car sold irrespective of color? The answer to each question will be put in separate columns. I have only included January but I will do this for the entire year of 2010 and also I will do this for all of the names in my database. I think there are about 300. When was the last time ANDY sold a RED car? The answer should be 1/12/2010 The answer will be put in ROW A COLUMN I When was the last time ANDY sold a car irrespective of color? The answer should be 1/12/2010 The answer will be put in ROW A COLUMN J When was the last time BILL sold a RED car? The answer should be 1/10/2010. The answer will be put in ROW B COLUMN I When was the last time BILL sold a car irrespective of color The answer should be 1/11/2010 The answer will be put in ROW B COLUMN J I have attached a thumbnail of a sample Database
View Replies!
View Related
Index/match/vlookup And ODBC SQL
I want to create a formula that will use a database table as a lookup for index/match and vlookup type functions. I have my ODBC connection connecting to a mysql database and am successfully able to run sql queries through excel. Is there a way to get index/match/vlookup formulas to use the database table as the lookup range?
View Replies!
View Related
VLOOKUP -- Automatically Change Column Index
Is there a way to automatically change the column index number in the VLOOKUP formula when copying the formula to columns? For example, when I copy a VLOOKUP formula from column A to column B, the cell references will change, but the column index remains the same. I'd like the column index to be increased by 1.
View Replies!
View Related
Vlookup, Index, Match, Offset, What Combination Should I Use?
I have attached an example s/sheet. Basically this is an excerpt of the data that sits in a pivot table. What I want to do is from another sheet query this data. I don't want to use another pivot table as they are quite hungry in terms of memory and the data source we have is quite large. In essence what I want to achieve is in cell G2 the user enters a code. A function (vlookup?) will then scan column A to find that code. The function then needs to look across and sum the total of Requests and Responses for all the dates. Whilst the dates may change, the number of dates will remain the same. Once it has summed them it needs to return the totals to cells G4 and G5. Additionally it needs to fill in the relevant total (offset?) for the corresponding week as detailed in columns H-AH. It seems quite a simple lookup issue but I am not very versed in nested lookups. I have looked around and it seems INDEX woudl do the job but I am at a loss on how to construct this type of function.
View Replies!
View Related
Formula Referencing Previous Sheet
After a formula to copy the contents of a cell in the previous sheet in a workbook, so that if I was to copy the last sheet in a workbook the formula would automatically reference the cell from the copied worksheet and so on if I copied tht one. Hope this makes sense I have a lot of formulas referencing the previous sheet and everytime I copy this sheet to create a new sheet I have to change the sheet number in the formulas. eg, in sheet 8 this formula get info from sheet 7 cel J30 ='7'!J30 when i copy the sheet to create a new one (Sheet 9) I would like the new formula to automatically be ='8'!J30.
View Replies!
View Related
Referencing Cells Dependent On Sheet Name
I have a workbook that has a number of sheets with various project stages and dates on them. These details are arranged in small tables displayed vertically down the page. Each worksheet's name is the project code - e.g. 30033_99 I have now been asked to create an overview page that displays all these stages and dates on one page. What I'm trying to do is get Excel to look at the column with the project code and then pull information from the worksheet with that name.
View Replies!
View Related
VLOOKUP And Identifying Column Index With An Input Cell
Is there a way to reference a cell value instead of using a static value for col_index_num? For example - Instead of telling it to look in the 5th column of Sheet2, I would like it to look in the column were the heading (row 2) in Sheet2 is equal to the value of O2 in Sheet1. Here's another example - Normal formula: VLOOKUP(a2,Sheet2,5,FALSE) What I'd like: VLOOKUP(a2,Sheet2,column where row 2 equals the value in 'Sheet1'!O2, FALSE)
View Replies!
View Related
Vlookup Or Similar With Variable Col Index Number Value
i am looking to create a vlookup but with the ability to easily change the column number index so that i can use different columns. As an example. In a worksheet i have a table with the names of cars in column A starting row 3. Column B to m Row 1 is headed Jan to dec, row 2 same columns is a country name eg UK. Column N to Y row 1 is Jan to Dec again and row 2 of these columns is a diff country say Germany. This repeats for a few more countries. The data within Row 4 for these columns i.e per car is all prices. The table therefore shows the prices of cars per country per month. I then have a seperate worksheet for each country where the cars are again listed in column A and Jan to Dec is in column b to M but the data is hard coded being the number of cars. I would like to use column N to link to 1 of these months hard coded counts dependant on what month i decide to forecast on. The easy way being that if i wanted to use Jan count number i would link the count for that car type to =b4 etc. Is there an easy way to allow me to change the link should i decide i want Feb ? The second question is within each countries worksheet i want to bring into column p the countries related car price for a month i select. It may be that the count number differs from the price i select.
View Replies!
View Related
VLookup/Index (round-down E3 And Find Its Corresponding Row In The Table To The Right)?
I need a formula for F3 that will round-down E3 and find its corresponding row in the table to the right and find its intersection with the coating listed in I3. Does that make sense? I've tried, to no avail: =VLOOKUP(E3,$J$3:$Q$19,MATCH(I3,$K$1:$Q$1)+1) =INDEX($K$3:$Q$19,MATCH(E3,$J$3:$J$19,1),MATCH(I3,$K$2:$Q$2,0))
View Replies!
View Related
Referencing Cells From Another Sheet, Dealing With Blanks
I have a sheet which I want to populate from another sheet within the same workbook. I am using the following, where Data = original worksheet, T2=cell to be displayed: =Data!T2 When i do this for the whole spreadsheet, where there are blanks it is entering "0" or in the date fields, 01/01/1900. Is there any easy way of defaulting them to be blank if there is no content in that cell?
View Replies!
View Related
Referencing Active Cell's Value From Another Sheet
I'd like for users to click in a cell in col A in a sheet named "Period7", have the cell value placed in cell C11 in a sheet named "Per7Report," and change the focus or active sheet to sheet Per7Report. Can this be done simply by clicking in a cell, or must a command button be inserted into each cell (note - odd rows only) in col A in Period7. on the code to do this? Note that there is a formula in col A in sheet Period7
View Replies!
View Related
Referencing Sheet Code Names By Variable
I have a set of worksheets (Sheet31 through Sheet49 by codename) produced by a machine in the lab. I want to create a summary sheet that references cells in those worksheets. Rather than go through the annoyance of doing this manually 40+ times I'm working on creating a macro to populate the summary sheet for me. This is what I have so far For J = 31 To 49 ResultSht = SheetJ.Name Sheet1.Activate ActiveSheet.Range("A4").End(xlDown).Offset(1, 0).Select It hangs up on the "SheetJ.Name" however. My objective is to be using the object SheetJ, where the object SheetJ is the codename of the results sheet I'm trying to reference (for example, in the first pass through the loop it would be Sheet31). Could someone point out my mistake in this object reference?
View Replies!
View Related
Conditional Formating IF, Match, Index And Vlookup To Find Several Duplicated Value
This had been hunting me for weeks and I still could not come over it after weeks of study the conditional formating IF, match, index, Vlookup, etc to find several duplicated value, e.g Column B = Name 1 & Row B = Time and so on, where as Name will have data of Name 1 duplicated in different time, while row B, "Time"would change to a different Name and maybe it would go back to Name one. My problem was dont know which formula I can use in a different sheet to bring back the data to Name 1 did Task A at Time A, while Name 1 did Task B at Time K, etc. If this is not Name 1, then Name B replace above.
View Replies!
View Related
Vlookup, Match, Index: Calculation By Customer, By Service Type
Using Excel 2003 and am trying to do a calculation by customer, by service type. Attached is the workbook and I've tried numerous ways to do this. On the revenue calculation worksheet, I am tryng to calculate the type of service minutes from the data retrieve worksheet, multipled by the service rate on the rate table for the specifc type of minute by customer. I'd like to build it as a vlookup by customer and then by service type, but have run into difficulty.
View Replies!
View Related
#REF! Error Referencing Worksheet After Importing Sheet
I have a template i'm making that is full of formula references to sheets not yet in existance in the workbook. what i want to happen is this: My code imports data files, renames the tabs to 1, 2, 3, 4... The formulas i already have are set in the CONCATENATED tab.... an example of such a formula is: ='1'!$P2. so this should work, and yet it doesn't. the sheet is imported as it should be, the tab is renamed to 1, and yet the CONCATENATED sheet still shows #REF for the cell value. if i click in the cell, click in the text bar and enter out, the formula updates. there apparently is no option that i KNOW OF (although i'm sure there is something out there that does...) that will update this without me entering into the text bar and entering out. Question: how do i manually update all references once the sheets to those references have been imported?
View Replies!
View Related
Vlookup Referencing Cell With "left" Function
See the attached example for an illustration of my problem. Essentially, I am trying to reference the first two numbers of an account number when using VLOOKUP. The function then references a table with account classifications based upon the first two numbers of each 10 digit account. This seems so basic, but is driving me up the wall!
View Replies!
View Related
Referencing Selected Tabs To Print Selection & Update Table Of Contents Sheet
I searched but didn't find exactly what I needed. I have a workbook with 31 sheets. It is a price guide with each category on a separate worksheet. I figured out how to list the sheets on a separate tab. What my client wants is the ability to: 1. select certain categories for printing, the ToC, Cover and backcover pages have to print in every case 2. the ToC has to change depending on the sheets selected. I'd rather write some code and give him an an easy command button rather then teaching him how to select non-concurrent sheets and printing only active sheets. What I'm really stuck on is the updating of the ToC with active sheets only (category and starting page which changes depending on pages selected).
View Replies!
View Related
Sheet Index In Vba
I have the following code which is set to work for individual worksheets. How do I change this code so that the macro works for all worksheets starting from sheet index 10 onwards. Sub CopyDownFormulae() Dim rCell As Range Dim lStop As Long lStop = Cells(Rows.Count, 12).End(xlUp).Row For Each rCell In Range("N10:U10").SpecialCells(xlCellTypeFormulas).Cells Range(rCell, Cells(lStop, rCell.Column)).FillDown Next rCell End Sub
View Replies!
View Related
Get Sheet Index Number
Is there a straightforward way to find a sheetnumber based on the name of that sheet? Eg if I have 10 sheets and the fifth sheet is called "number5", I want to get a 5 based on an expression that uses the sheetname "number5".
View Replies!
View Related
Creating And Naming A New Sheet From An Index
I'm attempting to create a database on Excel 2007 to create a record of all the documents I use at work. At the moment I have an index sheet where I enter the indivudual project numbers. Is it possible in VB to take a value from this index sheet, copy an existing (template within the workbook) sheet and rename the new tab with the project number from the index? Example: As there will be many projects within the database is it possible to code it such that: New Sheet1 created from template within workbook -> Tab renamed according to value of 'Index!B4' New Sheet2 created from template within workbook -> Tab renamed according to value of 'Index!B5' New Sheet3 created from template within workbook -> Tab renamed according to value of 'Index!B6' and so on...... Further, is it also possible to automatically create the new sheet as soon as a project number is entered into 'Index!B4', 'Index!B5', 'Index!B6'? ie: Text entered in 'Index!B4' -> new sheet created and renamed automatically
View Replies!
View Related
Popup Menu For Sheet Index
I have a workbook containing multiple sheets of data. I have a macro to analyze this data but want to add a popup menu with a dropdown list of all sheets in the workbook. The idea is to have the macro prompt me to select which sheet to continue running on. I can't remember how to create an input box with a dropdown menu.
View Replies!
View Related
Change Sheet Index Numbers In VBA?
1Does Excel process worksheets (tabs) in the left-to-right order in which the tabs appear visually? Or in the order of the worksheets' index numbers as they appear in the VBE Project Explorer window? 2Is there a way to renumber or reassign index numbers to specific worksheets?
View Replies!
View Related
Index / Array Return A Value From Same Column In Another Sheet
I am currently looking at a simple data set spanning a few years of annual average data. I want to create a front sheet to show people in what year the maximum value was reached for each site but am having trouble returning the values...... The summary sheet is headed:...... I want the formula to say - find the summary sheet max value cell in the main data sheet row 2 (for XYZ) and return the corresponding column from row 1 (year). I've got myself in a muddle trying to create array data from the index function and want something simple. There are only about 30 rows so am happy to manually select the rows in question and repeat the formula entry so it doesn't need to be fancy.
View Replies!
View Related
VLOOKUP / INDEX / MATCH Function: Match Data From 2 Independent Sets??
I am trying to match data from 2 independent sets, formatted slightly differently so not sure which function would work best for me. From the attached file, I am trying to match the date and time stamp (in cell A1) with that from the other data (in this example in cell E1) and return the data (from cell F1) to cell C1. So basically any date and time stamp before 04/03/09 04:00 will return a value of 44 (this value should appear, therefore in cells C1 - C30)
View Replies!
View Related
|
TRACKER
