| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If and vlookup in macro
Hi,
I am looking a code to create a macro, where I can insert the if vlookup below (to avoid N/A) Thanks =IF(ISNA(VLOOKUP($C$2,Sheet1!$A:$C,2,FALSE)),"2",V LOOKUP($C$2,Sheet1!$A:$C,2,FALSE)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro - Vlookup | Excel Discussion (Misc queries) | |||
| vlookup macro | New Users to Excel | |||
| VBA Macro for VLOOKUP | Excel Programming | |||
| Please help.. VLookup Macro | Excel Programming | |||
| VLOOKUP in a Macro | Excel Programming | |||
Threaded Mode
