INDIRECT within VLOOKUP

[Jay Fincannon]

NewLook.xls

=VLOOKUP($G$2,'[Zips.xls]669'!$A$1:$B$73,2,FALSE)
Rows are added or deleted from time-to-time in the target worksheets
in Zips.xls
I need a way to update the table_array without going into the VLOOKUP
each time. There are 80 worksheets in Zips.xls and 80 VLOOKUPS in
NewLook.xls

this doesn't work.
=VLOOKUP($G$2,'[Zips.xls]669'!$A$1:INDIRECT("B"&$D$1),2,FALSE)
$D$1 =COUNT(B:B)
What do I do now?

 

[Pete_UK]

Try it this way:

=VLOOKUP($G$2,'[Zips.xls]669'!$A:$B,2,FALSE)

You can use full-column references with VLOOKUP.

Hope this helps.

Pete