vlookup

  • Thread starter Thread starter Steved
  • Start date Start date
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.
 
=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
 
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

Vlookup 6
Blank cell if #N/A 7
Vlookup and return sheet name also 2
Vlookup Function 3
#N/A 6
Character 3
Vlookup and If statement help 1
The formula works if I copy from Auckland Kilometres 4

Back
Top