Right, I now have vlookup working on the workbook (thanks Dave), however
this has now created 2 further problems for me......

1. How do I get vlookup to check several worksheets within a workbook
for results, at the moment I can only get the table array to look at 1
worksheet per vlookup cell. ie each of my customers is on a different
worksheet.



2. How do I configure my "results" sheet to list multiple results for a
search? ie Column 1 contains a unique number for each customer, column 2
contains a numeric area code (eg area 23 = SW England) and there may be
several customers in that area. I want to be able to search by either
customer number (vlookup seems to do this ok) OR area number (multiple
possible results)..........




--
Alec H
------------------------------------------------------------------------
Alec H's Profile: http://www.excelforum.com/member.php...o&userid=31042
View this thread: http://www.excelforum.com/showthread...hreadid=507154