Thread: Using IF and Vlookup functions
View Single Post
 
Old 12-14-2011, 01:05 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows XP Office 2003
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,943
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default
Hi

In B2 enter
Code:
=VLOOKUP(A2,'tab 1'!$A$2:$B$11,2,FALSE)
and pull down as needed


EDIT to be complete , in XL 2007 you can use
Code:
=iferror(VLOOKUP(A2,'tab 1'!$A$2:$B$11,2,FALSE),"")
and in XL 2003

Code:
=if(isna(VLOOKUP(A2,'tab 1'!$A$2:$B$11,2,FALSE),"",VLOOKUP(A2,'tab 1'!$A$2:$B$11,2,FALSE))
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote