| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
ISNA VLOOKUP any data prefixed with a "C7" cannot be found?
Is C7 just a prefix to a code (e.g C7ABC)? YES "C7200-I/O-2FE/E" What does your Vlookup look like now? " =IF(ISNA(VLOOKUP('Quote Calculator'!A4,'Price List'!$C$13:$D$28262,2)),"",VLOOKUP('Quote Calculator'!A4,'Price List'!$C$13:$D$28262,2))" Do you only want to lookup the part after the C7? - no I require to lookup the entire product code. Any suggestions?:) -- Mike Jenkins ------------------------------------------------------------------------ Mike Jenkins's Profile: http://www.excelforum.com/member.php...o&userid=29588 View this thread: http://www.excelforum.com/showthread...hreadid=492880 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| data validation using vlookup | Excel Worksheet Functions | |||
| Vlookup for data contained in a cell | Excel Worksheet Functions | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Using VLOOKUP to draw data from two columns | Excel Discussion (Misc queries) | |||
| Data Source Name Not Found | Excel Worksheet Functions | |||
Threaded Mode
