| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
vlookup avoiding #N/A
Hi! If anybody know a way around this I'll be forever thankfull. I have a standard list which uses vlookup to another list which varies. If there is not a match I get #N/A and that messes up my subtotals in the first list. I have tried variations with if, match and find but I can not make it work. N2=VLOOKUP(B2;Internal!B:C;2;FALSE) N2=FD312 Insurance Thanks in advance -- Lillian Eik ------------------------------------------------------------------------ Lillian Eik's Profile: http://www.excelforum.com/member.php...o&userid=24919 View this thread: http://www.excelforum.com/showthread...hreadid=384575 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
| Array Function with VLOOKUP | Excel Worksheet Functions | |||
| make a vlookup using a variable path | Excel Worksheet Functions | |||
| vlookup data hidden within worksheet | Excel Worksheet Functions | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Threaded Mode
