Vlookup References A Table In Another Workbook

Jul 7, 2007

In trying to construct a Vlookup formula that references a table in another workbook, I find that when I double click on the tab in the source workbook to insert the name, and then complete the formula with the column reference and a False statement, I keep getting an “Invalid” statement in the fx wizard when I try to solve this problem. By entering the name range by typing, I get a “#NAME?” error when I go to the wizard to see what I’ve done wrong.

This issue was addressed in the link that I searched for in the old help files and submit in this question. It seems that the issue was never resolved in that posting and I can’t figure out how to resolve this matter.

ADVERTISEMENT

VLookup On Table With Multiple Worksheet References

Jul 17, 2013

I have a question dealing with a variable column and cell reference I'm using. To make it simple here's what I have done. On the FRUIT tab I have the following table in location BU132 - BV161

Name Column
Apples A
Pears B
Corn 'VEGGIE'!A
Peas 'VEGGIE'!B

I'm using the following formula to get the location of a cell on both the FRUIT and VEGGIE tab that has the value.

=INDIRECT(VLOOKUP(CH61,$BU$132:$BV$161,2,FALSE)&CN61)

{where CH61-CH100 contains fruits or vegetables and where CN61 is a table that has the column reference which goes from 1 to 40)

This formula works great as long as the item is on the FRUIT tab. I can just drag the formula down the entire column and get my values for all the FRUITS listed in CH61-CH100. But, it doesn't work for any items in CH which are on the VEGGIE Tab. What syntax do I need to use in the cell next to Corn and Peas above to get this to work right?

View 2 Replies View Related

Open Workbook 2 From Hyperlink In Workbook 1 Breaks References?

Sep 17, 2012

I have set up a workbook (wb2) that has external references to another workbook (wb1). All is good and works fine when you open the 2 files from windows explorer. I have then put a hyperlink to wb2 from wb1. When you click on this link the file opens but throws up errors saying some of the named ranges cannot be found?

View 3 Replies View Related

VLOOKUP With Multiple References

Dec 6, 2008

I am trying to accomplish a task that uses the VLOOKUP function to retrieve data from another worksheet. The problem I am having is that it will only return one row of data.

In the formula below, there are multiple rows that contain the $C$4 reference.
I would love to figure out how to return all the rows that contain that
C$4$ reference.

=VLOOKUP($C$4,'Hot Zone Customers'!$C$2:T561,14,0)

View 8 Replies View Related

Vlookup References Between Worksheets

Dec 12, 2006

I have 3 Sheets (Sheet1, Sheet2, Sheet3)

Sheet 1
---------
ClassID

Sheet 2
---------------
AccountID, Fname

Sheet 3
----------------
FundID, FName

I want to match the value from Sheet3!FundID to Sheet1!classID and Add Corrospinding Sheet3!Fname value to Sheet2(Fname). I tried using VLOOKUP, MATCH & INDEX but somehow not getting the correct formula.

View 5 Replies View Related

Renaming Files And Changing Vlookup References

Dec 19, 2012

I have about 85 files that I need to rename. These files contain data concerning delivery and quality data of each of our suppliers...1 file per supplier.

Current File Name: SupplierA 2012.xlsx
New File Name: Supplier A 2013.xlsx

Is there a way to do mass rename the files..

and that leads to my second question...each of these files contain vlookups to 2012 data...which is contained in the a file with 2012 in the file name. I need to replace source data file (i.e. 2012 Index) with the new file containing the 2013 data (i.e 2013 Index). Is there a way to replace that source data across 85 or so files using some time of mass find and repalce? All the cell references remain the same

View 2 Replies View Related

Moving Worksheets With VLookup Between Documents Without Changing References

Aug 23, 2012

I'm working on an excel report that handles reporting for a large number of people. Another person at work is doing the VBZ coding, and I'm doing the formulas that aggregates the data. which has led to an interesting problem whenever I use a vlookup. I copied the sheets with the formulas from the test document I had been working on to an updated version. And all the vlookups automatically adjusted themselves to reference the document they had been created in. I had also moved over the tabs they were supposed to reference, but they keep looking at the old document. I spent an hour removing the references last night, but I don't want to do it again when I get the final product.

How to get excel to copy a formula EXACTLY as written, and not att in the name of the original document?

It should say
=VLOOKUP($A438,totals!$A$1:$AH$63,32,FALSE)

and instead it says
=VLOOKUP($A438,'[reporting formulas.xlsx]totals'!$A$1:$AH$63,32,FALSE)

View 2 Replies View Related

Table References Based On Cell Values?

Aug 13, 2012

I'm trying to put together a dashboard that is referencing a table. Now the dash board I would like to have it so I can change a value and the details will update based off of my selection. This is all drived off of named ranges and have that working. The part I don't have working is dynamically changing what part of the table is being referenced to.

i.e. Say i have modeling quality I have a formula that looks like this

=SMALL(IF(Table1[[#All],[Modeling Quality]]=$D$12,ROW(Table1[[#All],[Modeling Quality]])),ROW($M1))

Which works perfectly. However if I change modeling quality to say modeling experience which has different criteria i need the formula to look like this

=SMALL(IF(Table1[[#All],[Modeling Experience]]=$D$12,ROW(Table1[[#All],[Modeling Experience]])),ROW($M1))

Is there a way I can drive the table reference from a cell selection? I've tried referencing them by manually typing in the cell address to no avail.

View 3 Replies View Related

To Change All References In The Workbook Easy

Jan 8, 2009

I have many files that has a filepath references in the cell values, for example:

='\serverfolder1subfolder2[Filename.xls]Sheet'!$B$82

Is there a way to change all the references to direct to another place?

Filenames don't change, only the '\serverfolder1subfolder2 path

View 9 Replies View Related

A Formula In This Workbook Contains One Or More Invalid References

Feb 29, 2008

I have a rather complicated workbook with many VBA formulas. When I close it down a window displays "A formula in this workbook contains one or more invalid references". verify that your workbook contains a valid path, workbook, range name, and cell reference.

This only happens when I close the workbook. I seem to have all functionality. How can I find the invalid reference.

View 9 Replies View Related

Using References In Pivot Table Calculated Fields Formula

May 23, 2007

Worksheet A contains two columns, that maps individual operations to their unitary cost:
COLUMN 1 = a list of operations
COLUMN 2 = the cost associated with each operation.

I can do a vlookup on this worksheet to retrieve the cost of each individual operation.

On another worksheet, I have a pivot table with a field that produces the sum of operations performed by type of operation, eg.

operation 1 was performed 5 times
operation 2 was performed 7 times
operation 3 was performed 4 times

I want to add a calculated field in the pivottable, that would output the total cost per operation. The formula for the calculated field in thepivot table would be
= operation * vlookup("name of operation","range for lookup table",2,0)

... unfortunately, "references, names and arrays are not supported in pivottable formulas".

View 9 Replies View Related

Pivot Table Fields, Based On Column References

Sep 26, 2007

I have a pivot table which draws data automatically from a database

What I would like it for the customer field of the pivot table to only equal the customers which are present in another worksheet (Column A:A)

View 9 Replies View Related

A Formula That References A Table Based On Contents Of Another Cell

May 20, 2008

Here is what I am trying to achieve:

I have a workbook with two tabs, on the first one there is one column and the top of the column(A1) is a dropdown containing the options 'Boy' or 'Girl'.
One the second worksheet I have two named tables (Boy and Girl) - these tables each contain a single column array with 5 names in each (so we have a table of 5 boys names and a table of 5 girls names)

What I want to happen is when a user selects an option from the dropdown in A1 the cell below(A2) is populated randomly with a name from the corresponding list.

I have achieved this initially using the following formula:
=IF(A1="Boy", INDEX(Boy,RandInt(1,10)), INDEX(Girl,RandInt(1,10)))

This works fine, but I will need to expand this for several dropdown options, so my new workbook will have a dropdown of car makes, and each make will have a list of the models associatied with the car make (e.g. Ford: Fiesta, Escort, Mondeo...)
But I do not want to have a ridiculously long nested IF statement for every car Make, so what I want to do is something along the lines of the following:

=INDEX([CONTENTS OF A1],RandInt(1,10))

So I use the text selected from the dropdown in A1 as the TableName in my formula - however, I cannot retrieve that to use in the formula without it coming back as a text with the "" included and my formula errors!

View 9 Replies View Related

Formula That References A Cell Where Workbook Is A Variable

May 24, 2007

Say cell C5 contains the name of a project (workbook). eg

C5 = "[Project1]"

In my current workbook, I want to find the value in cell B8 of Sheet1 of the project shown in C5. If I wrote this directly, it would be "='[Project]Sheet1'!B8"
But the name of the project is a variable shown in cell C5 (as explained above). So I need a formula that will find the value in cell B8 of sheet1 of the project shown in C5.

View 7 Replies View Related

VLOOKUP With INDIRECT (become Dynamic As The Table Array Part Of The Vlookup Will Change)

Aug 18, 2009

I have a Vlookup which I want to modify so that it can become dynamic as the table array part of the vlookup will change.

So the basic vlookup is as follows:
=VLOOKUP($R$3,ATTRIBUTION_FACTSET!$M$60:$P$73,2,0)
but the data I am looking for wont always be in the range M60:P73.

So I tried to make it dynamic by doing the following:
=VLOOKUP($R$3,INDIRECT("ATTRIBUTION_FACTSET"&"!M"&U1&":P"&V1),2,FALSE)
The idea being that U1 and V1 would be numbers that can change so in this case U1 would equal 60 and V1 would equal 73

This vlookup is giving me #N/A and no matter how I modify it I cannot get it to work.

View 3 Replies View Related

How To Reference Other Sheet Names In Workbook But Keep Cell References The Same

Oct 7, 2013

Within one workbook I have 15 sheets, 13 are for separate divisions within the company, 2 are used to present sums across the 13 sheets. All 13 sheets have identical columns and rows, with unique numbers in each cell. Right now I am manually selecting the cells to reference in my master sheet, =sheet name!cell+sheetname!cell+sheetname!cell - so and and so on. How can I reference the sheet name once, and then all of the cells to SUM? =sheetname!(c4+c14+c24+c34) etc?

This would let me be able to copy the formula from cell to cell, and only have to change the sheet name each time.

View 3 Replies View Related

2007 Macro Relative References Works On Only One Workbook

Oct 8, 2009

In Excel 2007 I am creating a macro with the "relative references" setting turned on. I want to repeat some tasks like: go to column A, sort, hide columns B thru F, hide columns H & I, return to column A.

Every time I try to create this macro by capturing key strokes, it inserts the workbook / worksheet name in the macro! Kinda defeats the ability to use it in any other workbook.

I am recording the macro in the PERSONAL.XLSX workbook. I have other macros that successfully perform in any workbook they are used in . . . but today I can't create one that doesn't incorporate the name of the original sheet it was recorded in.

View 12 Replies View Related

Copied Worksheet With Macros Still References Original Workbook

Oct 25, 2007

I have a workbook within which i have a worksheet that contains a lots of macro code (coded by me). As the workbook gets used by various people, i need to copy the worksheet and the macros across to the updated workbook, which doesnt contain the macro worksheet at all.

I have tried to copy it across by clicking on its tab and using the move or copy facility. This copies the sheet across as required. But for some reason, the macros all reference the old workbook. A small bit here for example for some reason opens up the old workbook and then performs the code in the old worksheet:

Sub SelectAll()
For i = 12 To 20
Set curcell = Worksheets("Form Generator").Cells(i, 3)
If curcell = False Then
Cells(i, 3).Value = True
End If
Next i
End Sub

As curcell is equal to worksheets...() i would have expected it to use the local worksheet, ie the one that the macro is attached to. So why is excel proactively hunting out the old workbook and sheet? is the method i used to copy across the sheet with the macros incorrect? If so, how should i go about it?

View 3 Replies View Related

Data Table Is Pasted In For VLookUp - Not Have To Redo Table Name Each Time

Jun 2, 2013

I created a lookup table that works quite well. It even has if statements in the LookUp Formula. However, I have to update the table it pulls the information from each day. I wind up recreating the range each time because the table always has more rows each time. Is there a way I could just paste the table in each day and not have to change the range? The columns never change.

View 9 Replies View Related

Lookup Up Entire Table Not Just Column In Table Like Vlookup Does

Jun 5, 2014

I'm trying to see if you can look up multi columns for a number and when it finds it return back to one column and return that data?

I am trying to sort out territories for a state I work on; the territories are divided up by zip codes.

i.e.
A B C D

territory 1 12345 54321 11222
territory 2 22222 33333
territory 3 44444 55555

and what I want is to say put a formula in cell B3 on Sheet 1 pointing to cell C3 that has zip code 33333. I want it to then take that and look in Sheet 2 and search A1:D3 and when it finds 33333, return "territory 2" back to cell B3 on Sheet 1.

View 3 Replies View Related

Excel 2007 :: Change Source Workbook For All External References At Same Time But Avoid Browsing?

Jan 7, 2013

Need to create Working order (in Excel 2007) for filling machine in my factory. Working order is changeable from day to day and the deference is product quantity. Product quantity in working order [File - Working order] is changing according to the each sales plan [7-Jan-13, 8-Jan-13] - (File Working order is Linked to the appropriate sales plan in this case - [7-Jan-13]).

Anyway, I need to change the source workbook "sales plan" from [7-Jan-13] to [8-Jan-13] by changing source workbook name in red cell [File - Working order] and not to browsing location?

All source workbooks [sales plan 7-Jan-13, 8-Jan-13]are at the same location in the same folder, only difference is the source workbook names. So, is it possible to change source workbook name (File - Working order - red cell) for all external references (File - Working order - green cells) at the same time, and avoid annoying browsing?

View 14 Replies View Related

Changing Hard Coded Column References To Variable References

Oct 22, 2009

I have a number of statements within the Sheet Event Code (Excel 2007). Three times lately I have added a column and had to go back into the code and find all of the references that needed changing to reflect the new column.

I have been working on this for a couple of days and even tried EE, but to no success.

I have read that Defined Names / Constants should be used as often as possible, but even trying that, the VBA code errors out or "hangs up". Even within Bill Jalen's book (VBA and Macros 2007), there is nothing that addresses this, especially using Intersect.

Private Sub Worksheet_Change(ByVal Target As Range)
Dim rng As Range

On Error GoTo mEnd
Set rng = Sheets("Log").[F14:F10000]
If Not Intersect(rng, Target) Is Nothing Then
If Target = "" Then
With Sheets("Log")

View 9 Replies View Related

Copy Cell Contents Between Tabs Provided Cell References Match (VLOOKUP)

Apr 29, 2014

I have 2 inventory reports: what my store has and what my supplier has. I need to copy Tab1:K# to Tab2:T# provided that Tab1:A#'s contents match Tab2:A#'s contents. The A column represents the SKU of the item, but there is a difference in the amount of SKU's in each (my store sells ~6,000 items, supplier has ~10,000 items), so it's not as simple as sort by column A and copy pasting column K to column T.

For instance:
On Tab 1, A2's value is [1], K2's value is [9.38].
On Tab 2, A70's value is [1], K70's value is blank, but I need it to be [9.38], to match Tab 1's respective SKU.

I almost thought I had it figured out with VLOOKUP, but I cant seem to get it right... It doesn't reference the correct number.

Screenshots for reference

First tab, from the wholesaler: [URL]
Second tab, store's stock: [URL]

View 2 Replies View Related

Converting Absolute References To Relative References In Formulas?

Feb 10, 2014

I set up formulas to count text characters in a range of cells. I'm tracking attendance and payments for a small yoga studio.

All I need to do is count "Y"s for prepaid attendance and "DI"s for drop-ins. I have the formulas working but they are absolute so inserting a row will break my sheet.

=COUNTIF(E14:Z14,"*Y*")
=COUNTIF(E11:Z11,"*DI*")

View 1 Replies View Related

Structured References And With Cell References I Get A Column Of Zeros

Nov 25, 2007

It is suppose to be that if the employee is "FT" and has worked >=4 years the return is 15. But if the employee is FT and has worked 2 years but less than 4 years then it is suppose to return 10 (these are days off) Or if the employee is FT and has worked 1 year, but less than 2 then it should return 5 days off. And all the others in the column get no days off.

I have tried to do it with structured references and with cell references I get a column of zeros!

View 9 Replies View Related

Userform VBA - VLookup Data Range From One Workbook And Populate Into Another Workbook

Feb 9, 2013

what VBA is required to have a combo box in a userform look up data in a different workbook, then populate that data into the drop down list of that combo box for a user to select.

I have managed to successfully create a vlookup for a combo box in a userform that looks up data in a named range in another worksheet within the same workbook and then populate that data into a field in a worksheet within the same workbook. However, I want to change this so the combo box on a userform (in one workbook) will look up data from a named range in a second workbook without opening the second workbook. At the moment, the code I have that will 'submit' the user selected data from the combo box drop down list works.

The code that has worked so far to vlookup data for the combo box from a worksheet within the same workbook is:

Code:
Private Sub UserForm_Initialize()
Dim pName As Range
Dim ws As WorksheetSet ws = Worksheets("vlookupsheet")
For Each pName In ws.Range("ProjectName")
With Me.cboProjectName
.AddItem pName.Value
End WithNext pName
Me.cboProjectName.SetFocus
End Sub

Do I need specify the file path of the second workbook that will contain the data for the combo box as well as the name of the worksheet and named range in that second workbook?

View 4 Replies View Related

VLookup Table To Another Table That Has Multiple Values

Jun 24, 2014

Vlookup a table, to another table that has multiple values.

E.g.

Table
GPASP002

Look up table - need to return second coloum but not the first value, all the values?
GPASP002 KZASP100
GPASP002 KZASP500
GPASP002 KZASP600
GPASP002 KZASP501
GPASP002 KZASP502
GPASP002 KZASP601

View 2 Replies View Related

Change Static References With Lookup References

Mar 2, 2009

I am using the dsum formula to sum some values...the formula in B2 is:

=DSUM(BaseSistemasFebrero,"vlfinf",OFFSET('Planes Entidades'!B$1,0,0,COUNTA('Planes Entidades'!B$1:B$49),1))

The Planes Entidades sheet the data is layed out like this: ....

View 9 Replies View Related

Lookup Table In VBA Rather Than VLookup Table?

Nov 23, 2011

I get a file every day that contains online orders for a client. They have made the state and country fields on the order form free text, so sometimes the State field has CA, sometimes California, sometimes even Cal or Cali. Oregon may be represented as OR, Oregon, or Ore (and one time even Orygon.)

The country field may have US, USA, United States and sometimes United States of America.

Well, they need this data imported to their system with the states fully spelled out: Oregon, California. And the country spelled out as well: United States, Canada.

Right now I have a lookup tables worksheet that I just have a macro run a vlookup on. But I'd like to know if there is a way I could just put it all in the code, without the external tables.

i.e. some code that, in English, would basically say, "If the value of any cell in column K is among these values, replace it with those values, otherwise just leave it as it is". Could I do that while containing the two sets of values right in the code rather than on a worksheet?

I really just want to replace the standard abbreviated state/country codes with the full text, and if the value does contain Cali or Ore, let them manually make the change. Hopefully that will finally nudge them to just make the online order form utilize a drop-down list of states and countries, rather than free text.

View 1 Replies View Related

VLOOKUP And MAX For A Table

Mar 18, 2014

I have an excel assignment that I am stuck on the last question. The questions is as follows:

"Make cells B7:M21 a range called "Data". Using this range, write a function that displays the names of the club's most extravagant and frugal members in cells I28 and I29. This formula may be somewhat tricky. If you cannot do this simply use functions to identify the highest and lowest monthly payments instead."

I have named the range and I have been trying to use a combination of VLOOKUP and the MAX function to return the Last Name to I28 and I29, but I just can't get it to work.

A3-1402-W14-Q1.xlsx

View 3 Replies View Related

Bug In A VLOOKUP Table

Aug 26, 2008

I have a VLOOKUP table with 805 rows and 88 columns (A5 to CJ805). When asked to display the figure in column 84 (CF) relative to that in Column 1 (A), i.e. for a figure in Cell A75 it should display CF75, it sometimes displays the figure which is 1 row above, i.e. CF74.

View 9 Replies View Related

Table Refererences In Vlookup

Jul 29, 2009

Is it possible for me to use the contents of a cell to change what table is being looked at in a vlookup?

E.g. lets say i have a bunch of data which is split into months with each month having it's own table. In cell L3 i have a formula to display the current month from today's date from H3 (using =today()).

Therefore when using a lookup i want to refer to L3 which effectively has in the title of the table i want to look at.

View 2 Replies View Related

VLOOKUP Vs Pivot Table

Jan 29, 2010

In creating a new sheet to allow for multiple piece of information to auto fill; I am struggling on a small VLOOKUP issue. On my parts information page (where the info is being pulled from) I want to be able to separate out data based on the manufacturer while still leaving enough open/blank space for future additions. My issue is that with VLOOKUP every time I add to the current list(s) of data, I have to re-sort to alphabetic in order for it to work right. This means that the separation I am looking for disappears for the most part. Maybe I am doing something wrong or I am missing something, which if so, do Pivot Tables work better for this situation?

How my sheet is working is the user can pick from a list of items, click a button and the item is then transferred to another page, when it transfers the corresponding cells on the transferee page will auto fill with the rest of the info in those cells, thereby displaying not only the item picked but all of the realative data with it.

View 2 Replies View Related

VLOOKUP With Table Not Ascending

Oct 13, 2011

I'd like to carry out a VLOOKUP on a list of product. The product numbers contain numbers and letters, some start with several 0's. If i were to convert these product numbers to an actual number, the 0's are removed.

So, when I attempt to place the list in ascending order, it's not really in ascending order - it will start with the part numbers that Excel has defined as a number with everything else afterwards.

Is there anyway I can run a VLOOKUP without having to place the lookup table in ascending order?

View 6 Replies View Related

VLookup Table Name From Cell

Feb 29, 2012

I have 2 option buttons to select a data table

option1 = XData1
Option2 = XData2

When I click the option I want it placed the table name in cell:p4

In a vlookup, I want to reference that table name in cell p4 ex: VLOOKUP(C13,p4,$C$7,FALSE)

I have also named cell p4 to xData and tried: VLOOKUP(C13,xData,$C$7,FALSE)

View 3 Replies View Related

Vlookup Function To Look Up In A Table

Sep 29, 2008

I need to create a summary table of dates and data. The trick is I need the vlookup function to look up say 7/1/08 in a table that all the dates are of the format 7/20/08 and so on. Is there a way to have the vlookup return the proper data by ignoring the day.

View 9 Replies View Related

VLOOKUP Table Ranges

Nov 28, 2008

Is there anyway to, instead of indicating specific cells to be included in the range of a VLOOKUP table, designate the table range as whatever cells are selected in a spreadsheet.

The VLOOKUP formula is in a spreadsheet called "Template". The VLOOKUP table range will be in a spreadsheet called "Statement of Assets".

Here is the formula I have:

=VLOOKUP("Lookup Value",'Statement of Assets'!$A$122:$C$142,2,0)

But the row numbers in "$A$122:$C$142" is going to change depending on what plan number I am working on. Columns stay the same.

What I want is something like:

=VLOOKUP("Lookup Value",'Statement of Assets'!whichever cells are selected,2,0)

View 9 Replies View Related

Vlookup - Value Not In First Column Of Table

Apr 4, 2007

Is it possible to use the VLOOKUP (or similar function) when the value it is looking up is not the first column.

A B C
Kevin 8.00 140000003
Paul 8.00 140000001

I want to lookup the value in column C and return the value in column A. Kind of the reverse to this =VLOOKUP(E1,A1:C2,1,false)

View 2 Replies View Related

VLOOKUP Within Same Workbook?

Apr 11, 2002

I am trying to use vlookup within the same workbook (different worksheet) and i get nothing, what i am doing:

=VLOOKUP(c2,'filename'!'cellname'3)

View 7 Replies View Related

Pivot Table Using Data From Vlookup

Feb 5, 2014

I have a Takeoff sheet where an estimator enters a part# and the rest of the data is entered on the Takeoff sheet by using Vlookup to retrieve the information from the Products Sheet (there are about 12,000 products with 12 fields for each product). I need to then take all of the parts on the Takeoff sheet, and summarize the data, which is what Pivot Tables are for. The thing I cannot find out, is if this can be done. The machine keeps running out of memory (it has 32g, so I question that, and I tested with a 500 row sheet and got the same result), so I can never get the Pivot Table to actually create, or get a useful error message. Searching the web and this forum tells lots about Vlookup IN a Pivot Table, but not creating a Pivot Table from Vlookup data. I copied the data values to a new sheet to test the data and the Pivot created fine, so I believe the data itself is properly formatted.

View 1 Replies View Related

Using Cell Value For VLOOKUP Table Array

Apr 3, 2014

I have a spreadsheet with 51 worksheets - a "Master" worksheet and 50 datasheets (labelled 1-50). Within the "Master" worksheet the first column has numerical values ranging from 1-50.

One of the columns in the "Master" worksheet is a VLOOKUP that is trying to pull data, of which the table array is dependent upon the value in the first column. For example:

If cell A2 has the number 1 the VLOOKUP would be:
=VLOOKUP(E2,'1'!$A:$E,3,0)

If cell A2 had the number 2 the VLOOKUP would be:
=VLOOKUP(E2,'2'!$A:$E,3,0)

If cell A2 had the number 3 the VLOOKUP would be:
=VLOOKUP(E2,'3'!$A:$E,3,0)

etc.

Tried nesting an INDIRECT function with the VLOOKUP but it didn't work.

View 2 Replies View Related

ADVERTISEMENT