| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP referencing another workbook
Thank you for finding that! I pulled the information in my worksheet off an
AS400 Query, and it inserted a space in the front of each cell thas I was searching on. I did a quick find and replace, and it works great! Thanks for catching it!! Kathy "Gary Brown" wrote: =VLOOKUP(I2,[PLLIST.xls]Sheet1!$A$2:$C$500,3,FALSE) is fine, I have tested with this excat formula and it worked fine. I can only assume that the value in I2 does not exactly match the values in column A of Sheet1 in the workbook PLLIST, are you sure you don't have a space after the value in either I2 or in column A? -- Gary Brown ------------------------------------------------------------------------ Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084 View this thread: http://www.excelforum.com/showthread...hreadid=520620 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW DO I SUM TWO CELLS FROM ONE WORKBOOK TO ANOTHER WORKBOOK? | Excel Worksheet Functions | |||
| excel exits unexpectedly or hangs the second time I open workbook | Excel Discussion (Misc queries) | |||
| Can vlookup or hlookup look to other worksheets within a workbook. | Excel Worksheet Functions | |||
| Unprotect Workbook | Excel Discussion (Misc queries) | |||
| vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Hybrid Mode
