Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLookup in two Excel 2003 workbooks
Hello, could someone please help me with the following:
I am trying to use VLookup function to look up peoples names in column C in workbook named Aus.xls in worksheet named: Australia. I need VLookup to find the exact corresponding person's name in the other workbook named Int.xls in worksheet named: International. Once the person's name is matched in workbook named Int.xls in worksheet named: International, then I need VLookup to return the person's corresponding employment number from column E in workbook named Int.xls in worksheet named: International back to column T in workbook named Aus.xls in worksheet named: Australia. I was trying to use this VLookup function but it only works in one workbook only. Any help would be greatly appreciated, Kind regards, Chris. =IF(ISNA(VLOOKUP(C3,$A$2:$S$50000,5,0)),"",VLOOKUP (C3,$A$2:$C$50000,5,FA LSE)) *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLookup in two Excel 2003 workbooks
=IF(ISNA(VLOOKUP(C3,
'C:\work\[int.xls]international'!$A$2:$S$50000,5,0)),"",VLOOKUP(C3, 'C:\work\[int.xls]international'!$A$2:$C$50000,5,FALSE)) If int.xls is open when creating formula, you have not to bother with path, Excel insert it when closing int.xls. Regards, Stefi €˛Chris Hankin€¯ ezt Ć*rta: Hello, could someone please help me with the following: I am trying to use VLookup function to look up peoples names in column C in workbook named Aus.xls in worksheet named: Australia. I need VLookup to find the exact corresponding person's name in the other workbook named Int.xls in worksheet named: International. Once the person's name is matched in workbook named Int.xls in worksheet named: International, then I need VLookup to return the person's corresponding employment number from column E in workbook named Int.xls in worksheet named: International back to column T in workbook named Aus.xls in worksheet named: Australia. I was trying to use this VLookup function but it only works in one workbook only. Any help would be greatly appreciated, Kind regards, Chris. =IF(ISNA(VLOOKUP(C3,$A$2:$S$50000,5,0)),"",VLOOKUP (C3,$A$2:$C$50000,5,FA LSE)) *** Sent via Developersdex http://www.developersdex.com *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLookup in two Excel 2003 workbooks
Thanks Stefi - very much appreciated,
Cheers, Chris. *** Sent via Developersdex http://www.developersdex.com *** |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLookup in two Excel 2003 workbooks
You are welcome! Thanks for the feedback!
Stefi €˛Chris Hankin€¯ ezt Ć*rta: Thanks Stefi - very much appreciated, Cheers, Chris. *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2003 Excel Workbooks | New Users to Excel | |||
How do I combine five Excel 2003 workbooks? | Excel Worksheet Functions | |||
I cannot seem to print certain workbooks from Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 cannot copy between workbooks | Excel Discussion (Misc queries) | |||
Excel 2003 Workbooks.Open with CorruptLoad=xlRepairFile fails on Excel 5.0/95 file due to Chart, with Error 1004 Method 'Open' of object 'Workbooks' failed | Excel Programming |