Using INDIRECT Function For VLOOKUP?

May 8, 2014

I am having issues using the INDIRECT function to lookup data from a sheet with the same name as that appearing in a given cell. For example, in cell D27 i have the text "S1_358_810" (Not including quotations). I also have a sheet named "S1_358_810". My formula is as follows;

Formula:

[Code] .....

However this is returning #N/A. There is a list of numbers in sheet S1_358_810 in column N and from that I want the value in column Q (thus 17).

View 11 Replies

Using Indirect Function In Vlookup Should Give Corresponding Value For The Particular Name?

May 11, 2014

I have two workbook, test1 (master file) and the other one is test_10_05_2014 with 100 some of them being updated daily. The last portion of the file "test_10_05_2014" is the date and we have different file on daily basis.

using Indirect function in vlookup should give corresponding value for the particular name. Formula used is giving error,

[VLOOKUP(A2,Indirect(" ' "&E1&" ' !$A$2:$X$1000),6,FALSE)]

View 2 Replies View Related

Excel 2007 :: VLookup Formula With Indirect Function

Mar 19, 2013

Code:
=D5-VLOOKUP($C5,$C$45:$F$80,2,0)

I have formulas such as above in my Worksheet. So the above is in Cell H5

For the Range $C$45:$F$80, I am inserting rows (So moving down the data) and copying data from $C$5:$F$40 as values into the new space in $C$45:$F$80

I am doing the above using a macro, but when I run it I want this

Code:
=D5-VLOOKUP($C5,$C$45:$F$80,2,0)
to stay static, but instead I end up with

[CODE=D5-VLOOKUP($C5,$C$85:$F$120,2,0)[/CODE]

So my Table Array $C$45:$F$80 changes to $C$85:$F$120

How can I keep it as $C$45:$F$80

The other references in the formula seem to stay as I want them.

View 2 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

Using Vlookup & Indirect To Ref List And Vlookup Files

Sep 17, 2008

I have a spreadsheet (Need Data.xls) that needs to be filled out with a couple columns of data.

This data lays within 338 spreadsheets which have many items and may only have 2, or 3, or 50 that belong on my Need Data.xls spreadsheet.

I have a tab in Need Data.xls named "DIR" which has a list of 336 excel files that need to vlookup'd into.(not a separate file) They're all setup with this format:

View 14 Replies View Related

Embed An INDIRECT() Into A VLookup()

May 21, 2009

I just learned how to do an Indirect.

So that i can make many pages without having to go through and change everything.

I want have excel search for a name contained in A1 in a table (so i use vlookup).
then but i want be able to change the sheet name easily.

so what i need is something like this:

=VLookup(A1,(INDIRECT("'" & B2 & "'!")),$b$6:$S$23,2,)

this does not work.

But i want the sheet name to be the thing INDIRECT looks up, while the name in A1 is the thing that the VLookup is trying to find.