Thread: VLOOKUP help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John John is offline
external usenet poster
 
Posts: 2,069
Default VLOOKUP help

I can't get =VLOOKUP(A5,MonthTable,4,FALSE) to show anything but #N/A.
This vlookup fcn is on Sheet1 in cell R5.
Sheet1 cell A5 contains integer 9002
MonthTable is range Sheet2!$A$17:$D$18, the following 2x4 table:
Col A B C D
Row 17 9004 Plate - 599.84
18 9002 Pledge - 14,390.00
I want it to return 14,390.00.

I appreciate your help, -John