| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif and Vlookup in a single formula
I given the following formula as one
=IF(COUNTIF([item.xls]Sheet1!B:B,G7),VLOOKUP(G7,[item.xls]Sheet1!B:L,11,0),0) If there is no record matching with item.xls, the result should be 0 otherwise the result will be 11th column. But it working fine except if there is no record to match it is not giving the result as 0 in G7. Please help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup and using single quote | Excel Worksheet Functions | |||
| Anyway to put logic into a single countif, sumif etc? | Excel Worksheet Functions | |||
| COUNTIF for single word in text | Excel Worksheet Functions | |||
| Vlookup partial text from a single cell | Excel Worksheet Functions | |||
| Can vlookup return multiple matches in a single cell? | Excel Discussion (Misc queries) | |||
Threaded Mode
