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