| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
V Look Up Annoying Function Help Needed
I have a V look up function on my spreadsheet and it has one annoying thing that I hope you can help with. In all the columns where the look up values are pasted are the symbols #N/A before I insert numbers Is there anyway I can set a lookup but not have the #N/A in each column and when a value is found for the box it just inputs the data I need it to. -- tweacle361 ------------------------------------------------------------------------ tweacle361's Profile: http://www.excelforum.com/member.php...o&userid=32202 View this thread: http://www.excelforum.com/showthread...hreadid=519494 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
V Look Up Annoying Function Help Needed
=if(a1="","",vlookup(A1,table,3,False))
is the approach I would take. -- Regards, Tom Ogilvy "tweacle361" wrote in message ... I have a V look up function on my spreadsheet and it has one annoying thing that I hope you can help with. In all the columns where the look up values are pasted are the symbols #N/A before I insert numbers Is there anyway I can set a lookup but not have the #N/A in each column and when a value is found for the box it just inputs the data I need it to. -- tweacle361 ------------------------------------------------------------------------ tweacle361's Profile: http://www.excelforum.com/member.php...o&userid=32202 View this thread: http://www.excelforum.com/showthread...hreadid=519494 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Annoying Pop up box in function | Excel Programming | |||
| Annoying Pop up box in function | Excel Programming | |||
| Annoying Pop up box in function | Excel Programming | |||
| Annoying Pop up box in function | Excel Programming | |||
| Annoying Pop up box in function | Excel Programming | |||
Linear Mode
