| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLookup Troubleshooting #N/A
I am working on a sheet that will pull the detail text associated with a
number, after the number is typed. I currently am using: =IF(A4<"",VLOOKUP(A4,openwork,2,FALSE),"") My array is approximately 8 columns by up-to 1000 rows. I have double and triple checked that the number I am looking up is in fact within the array, and I have made sure that both sheets have numbers formatted as numbers (not text). Any ideas on what to look for next? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Troubleshooting | Excel Discussion (Misc queries) | |||
| Troubleshooting Spreadsheets | Excel Discussion (Misc queries) | |||
| Troubleshooting my IF formula | Excel Discussion (Misc queries) | |||
| SUMPRODUCT troubleshooting | Excel Worksheet Functions | |||
| troubleshooting | Setting up and Configuration of Excel | |||
Threaded Mode
