Thread: vlookup
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
GTVT06 GTVT06 is offline
external usenet poster
 
Posts: 141
Default vlookup

On Mar 19, 12:11*pm, Theresa
wrote:
Hi, I am trying to create a formula and I get #REF in return. *The formula is
=VLOOKUP(B190,I190:I241,2,FALSE). *What am I doing wrong?


Is Column C blank in the referenced cell? If so, that's the reason for
the #REF error, there has to be a value in that cell to avoid that
error, or you can add an IF/ISERROR function to your formula