Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Vlookup ref!
We are doing a vlookup for a date cell in both workbook which is in column D
this is the formula =VLOOKUP(B10,'C:\Documents and Settings\Administrator\My Documents\[calling_.XLS]Customers'!$A$4:$I$58,4,FALSE) but we are getting a #REF! both are date fields also it is in row 30 column d? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Vlookup ref!
Did you type that reference in? If so then open up both workbooks, tile them
so you can see them both and then use the mouse to select that range on the calling_.xls workbook from within the formula. Close the target workbook and it will automatically create the correct range reference for you. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "dk" wrote in message ... We are doing a vlookup for a date cell in both workbook which is in column D this is the formula =VLOOKUP(B10,'C:\Documents and Settings\Administrator\My Documents\[calling_.XLS]Customers'!$A$4:$I$58,4,FALSE) but we are getting a #REF! both are date fields also it is in row 30 column d? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Vlookup ref!
something is not working it will not input selected range
"Ken Wright" wrote: Did you type that reference in? If so then open up both workbooks, tile them so you can see them both and then use the mouse to select that range on the calling_.xls workbook from within the formula. Close the target workbook and it will automatically create the correct range reference for you. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------Â*------------------------------Â*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------Â*------------------------------Â*---------------- "dk" wrote in message ... We are doing a vlookup for a date cell in both workbook which is in column D this is the formula =VLOOKUP(B10,'C:\Documents and Settings\Administrator\My Documents\[calling_.XLS]Customers'!$A$4:$I$58,4,FALSE) but we are getting a #REF! both are date fields also it is in row 30 column d? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup a Vlookup | Excel Worksheet Functions | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |