| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP - Not returning the proper number (Caro)
I have this function:
=VLOOKUP(S2,'MFD Cost Table'!$B$3:$C$13,2) The lookup value is either 5655, WC 255 or WCP36. The formula brings back the price of the lookup value. It does not bring back the right price for WC 255 or WCP36 even though they are entered correctly into the table. It does bring back the right price for the 5655. Am I doing something wrong? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP - Not returning the proper number (Caro)
=VLOOKUP(S2,'MFD Cost Table'!$B$3:$C$13,2,FALSE)
Look in HELP for the meaning of the 4th argument (FALSE) -- Kind regards, Niek Otten Microsoft MVP - Excel "Caroline" wrote in message ... I have this function: =VLOOKUP(S2,'MFD Cost Table'!$B$3:$C$13,2) The lookup value is either 5655, WC 255 or WCP36. The formula brings back the price of the lookup value. It does not bring back the right price for WC 255 or WCP36 even though they are entered correctly into the table. It does bring back the right price for the 5655. Am I doing something wrong? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting number into proper date format | Excel Discussion (Misc queries) | |||
| Convert number to text with proper accounting for Cheque Printing | Excel Discussion (Misc queries) | |||
| help to in setting up a proper Vlookup table and formula | Excel Worksheet Functions | |||
| vlookup returning a #N/A value | Excel Worksheet Functions | |||
| UDF not returning proper value - circular reference/multi workbook | Setting up and Configuration of Excel | |||
Hybrid Mode
