Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 " wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
vlookup error | Excel Discussion (Misc queries) | |||
REF# error using VLOOKUP | Excel Worksheet Functions | |||
vlookup error - recognition of value | Excel Worksheet Functions | |||
Fill down error for Vlookup | Excel Worksheet Functions | |||
vlookup weird error | Excel Worksheet Functions |