Vlookup in another workbook

[=?iso-8859-1?q?Luis_A=2E_V=E1zquez?=]

Hi Group,

Im trying to execute the following task:

i have workbook A thats made up of many sheets with 8 columns each. in
workbook B in need to run a search that looks in column 8(this column
has contains unique numbers) and when it finds a match in workbook A
it wiil copy the contents of the row in which that match was found.

Basically its a cross hair

 

[Guest]

So are you trying to lookup the value across multiple sheets of another
workbook? If so, then you may need to write your own function.

If you look in only one sheet, then consider using a helper column. Use
MATCH to find the correct row and OFFSET or INDEX to return the data at that
given row. This will cause the spreadsheet to find the correct row only once
whereas VLOOKUP has to find the record each time.

=MATCH(valueToFind,'WorkbookA.xls!'$H:$H,FALSE)
=INDEX('WorkbookA.xls'!$A:$H,row#,{1,2,3,4,5,6,7,8})

The INDEX function will return the entire row if you enter the formula
across 8 cells and use CTRL+SHIFT+ENTER. If you need help with this, let me
know and I can send you an example.

Matthew Pfluger

HTH,
Matthew Pfluger