|
|
|
|
#1
09-12-2011, 01:24 PM
|
||||
|
||||
Hi Karen,
Sure, if you are using Excel 2007 or later you can do it like this: =IFERROR(VLOOKUP(A2,'Sheet1'!$A$2:$B$141,2,0),"no match") If you are using Excel 2003 or earlier then you can do it like this: =IF(ISNA(VLOOKUP(A2,'Sheet1'!$A$2:$B$141,2,0)),"no match",VLOOKUP(A2,'Sheet1'!$A$2:$B$141,2,0)) 
|
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Using Vlookup & IF together | thelauncher | Excel | 5 | 08-25-2013 11:32 PM |
 Can i do this with a VLookup?
|
foodstudent | Excel | 1 | 01-21-2011 12:34 AM |
| Using IF & VLOOKUP together | junction | Excel | 7 | 11-18-2010 05:15 AM |
| Help with VLOOKUP | sakhtar | Excel | 2 | 07-24-2010 07:39 PM |
| vlookup question | Tony G | Excel | 9 | 03-28-2009 11:16 PM |
Windows 7 32bit 
Office 2010 32bit
Hybrid Mode