Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup in another workbook
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup in another workbook
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 "Luis A. Vázquez" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup other workbook | Excel Discussion (Misc queries) | |||
Vlookup on second WorkBook | Excel Programming | |||
Vlookup to closed workbook ? | Excel Programming | |||
Vlookup for two sheets in same workbook | Excel Discussion (Misc queries) | |||
VLOOKUP into another workbook | Excel Programming |