| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple VLOOKUP in an IF statement
Hi Richard,
Am Fri, 16 Nov 2012 16:21:42 +0000 schrieb Richard Doyle: 1 2 3 4 5 I then want to look to see if "1" is in column A of worksheet"Main", if it is then display "MAIN" if it is not then check column A of worksheet"Lower", if it is there display "LOWER" if it is nowhere then display "NONE" I had the following formula which works fine except for showing N/A instead of "NONE" you don't have to use VLOOKUP. Try: =IF(COUNTIF(Main!$A$1:$A$5,A1)0,"MAIN",IF(COUNTIF (Lower!$A$1:$A$5,A1)0,"LOWER","NONE")) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup, if statement, maybe an and statement | Excel Discussion (Misc queries) | |||
| If statement with vlookup link to multiple sheets | Excel Discussion (Misc queries) | |||
| If statement with multiple criteria and multiple results | Excel Discussion (Misc queries) | |||
| Multiple if statement with vlookup function | Excel Worksheet Functions | |||
| Using an IF statement, or VLOOKUP statement | Excel Programming | |||
Threaded Mode
