Thread: Vlookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Confused? Confused? is offline
external usenet poster
 
Posts: 2
Default Vlookup

Can someone help be understand why the data the the vlookupfunction is
returning is the value of the cell above the lookup up value. e.g
lookup value is 3
table array is:
1 A
2 B
3 C
formula result is B instead of C.