Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP help
I don't see anything wrong with your formula.
Is your MonthTable defined as the Name range? if not, it will not work you can either set up the MonthTable as Name range or use this =VLOOKUP(A5,Sheet2!$A$17:$D$18,4,FALSE) In addition, check to make sure that Col A on both sheets are real numbers, use ISNUMBER this will return TRUE if data is a number, and that there're no leading and trailing spaces, use LEN this will shows you the number of characters in a cell inculding spaces. Let me know its work out for you. -- HTH Pls provide your feedback by clicking the Yes button below if this posting is helpful This will help others to search the results in the archive better pls click on the Yes button below if this posting is helpful "John" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP help
Well, the function seems correct. But if the - 599.84 are in the same cell then in will not show the result. Further if the lookup value I blank then it will return #n/a. Chris ------ Convert your Excel spreadsheet into an online calculator. http://www.spreadsheetconverter.com -- Chris Bode |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |