Vlookup ref!

[dk]

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?

 

[Ken Wright]

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]

something is not working it will not input selected range

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
------------------------------­------------------------------­----------------

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?