VLOOKUP not working correctly!

  • Thread starter Thread starter Potsy
  • Start date Start date
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
 
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)
 
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 -
Click to expand...

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