Vlookup value not available error

[mquinlan]

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?

 

[Guest]

Hi,

Probably a syntax error or blank space at the end of some of the data or
maybe the last argument of the vlookup is set to TRUE instead of FALSE. If
you just need to remove the #N/A then:

=IF(ISNA(vlookup formula),"",vlookup formula)

HTH
Jean-Guy