I have a form which uses a dropdown list which ref. a column in a
seperate worksheet. I am using the VLookup to populate fields from the
array in the worksheet. I have entered 5 values for the look_up value
which work fine (all the vlookups find the corresponding values in the
array). The sixth and sevevnth values in the lookup return error:
value not available. Can not see any difference in formating of the
table array. Getting frustrated!!!! Any help?