Thread: vlookup
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default vlookup

Your lookup table is only one column wide, i.e. I190:I241, but your
third parameter is 2 meaning to return data from the second column.
Make your table wider.

Hope this helps.

Pete

On Mar 19, 5: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?