VLOOKUP not working correctly!

P

Potsy

hi

I have been using VLOOKUP on a few reports recently and it has been
working great, however, cannot seem to get it working on a particular
field. I am linking from a master file and linking to current
workbook.

When you select the job number in the workbook it populates all the
address fields etc fine from the master file, and also copies the name
ofr the Project Manager in (Cell Ref: D25), however from here I have a
table that details the mobile numbers and emails address of each on
seperate tab of current workbook called "Internal Contacts" thus:

=VLOOKUP(D25,'Internal Contacts'!A1:C5,2) however, just getting #N/A
reference in both fields. However, with one persons name it does
complete the fields correctly each time - strange!!!

Anyone know what I am doing wrong!!!

Cheers

Potsy
 
R

Roger Govier

Hi

If the data in Internal Contacts is not sorted, then you need to add the
optional 4th parameter to VLOOKUP of False or 0
=VLOOKUP(D25,'Internal Contacts'!A1:C5,2,0)
 
P

Potsy

Hi

If the data in Internal Contacts is not sorted, then you need to add the
optional 4th parameter to VLOOKUP of False or 0
=VLOOKUP(D25,'Internal Contacts'!A1:C5,2,0)

--
Regards

Roger Govier










- Show quoted text -

Great - just done it and it works a treat - at least i didn't waste
all Friday on this!!!! Thanks again!!
 

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

Top