vlookup

S

Steved

Hello from Steved
The below formula works on 11.06.04oplist.xls

=VLOOKUP(D1:D2000,A2:B2000,2)

Ok I would like please to have it work in another workbook
(Audit team replaces sheet1) the one below is my attempt
please point me in the right direction.


=VLOOKUP('[11.06.04 oplist.xls]Audit Team'!
$D$1:$D$2000,A2:B2000,2)

Thankyou.
 
N

Nimit Mehta

=VLOOKUP('C:\Documents and Settings\user\Desktop\[11.06.04
oplist.xls]Audit Team'!$D$1:$D$2000,A2:B2000,2)
Full path of your 11.06.04 oplist.xls
-Nimit
 
S

Steved

Thanks Nimit

-----Original Message-----
=VLOOKUP('C:\Documents and Settings\user\Desktop\[11.06.04
oplist.xls]Audit Team'!$D$1:$D$2000,A2:B2000,2)
Full path of your 11.06.04 oplist.xls
-Nimit
-----Original Message-----
Hello from Steved
The below formula works on 11.06.04oplist.xls

=VLOOKUP(D1:D2000,A2:B2000,2)

Ok I would like please to have it work in another workbook
(Audit team replaces sheet1) the one below is my attempt
please point me in the right direction.


=VLOOKUP('[11.06.04 oplist.xls]Audit Team'!
$D$1:$D$2000,A2:B2000,2)

Thankyou.
.
Click to expand...
.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Blank cell if #N/A 7
Vlookup 6
#N/A 6
Character 3
The formula works if I copy from Auckland Kilometres 4
Formula to reconize text or number please 1
Works if I copy F Col to A Col 6
Vlookup Function 3

Top