I'm using a VLOOKUP function to pull up a clientName from a 2nd
worksheet and apply it to the 1st worksheet (tab named Book2). My 2nd
worksheet (tab named ClientDB3) contains a client DB with the ClientID
and ClientName. The VLOOKUP fx is used by the 1st worksheet which is a
client report basically.

I have a column on the report page (1st worksheet) that has a list in a
dropdown box that fills with the clientID from the 2nd worksheet as they
are added to the Client DB (2nd worksheet). Both the ClientID and the
ClientName columns are defined to grow as entries are added in the 2nd
worksheet. I have a list dropdwon data validation defined for both
columns in the 1st sheet, could this be the problem???? Should I
eliminate the dropdown for the Name and only have the =VLOOKUP fx
used.

In book2 1st worksheet when I pick a ClientID from the dropdown box, I
would like the ClientName to automatically fill in adj column.

My fomula is:

=VLOOKUP(A8,ClientName,1,FALSE)

which is placed in the column adj to A8 (the ClientID column)


It returns a #NA value.


--
bwall
------------------------------------------------------------------------
bwall's Profile: http://www.excelforum.com/member.php...o&userid=26997
View this thread: http://www.excelforum.com/showthread...hreadid=466357