| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup to the left
I have the following in columns a and b:
_A__B_ Jan| 1 | Feb| 2 | Mar| 3 | etc... when a number is put into cell A15, i want A16 to return the month. this is the formula i have: =VLOOKUP(A15,A1:B12,1,FALSE) unfortunately, it's returns #N/A. I know how to work the vlookup when, for example, i'm looking up the month and i want the month number to be returned. I can't get vlookup to work when the lookup value is in column 2 of the array and the result value is in column 1. What am I doing wrong? Cheers comparini3000 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup and left function | Excel Discussion (Misc queries) | |||
| Can Vlookup check a cell to the left? | Excel Worksheet Functions | |||
| make a vlookup using a variable path | Excel Worksheet Functions | |||
| vlookup data hidden within worksheet | Excel Worksheet Functions | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Threaded Mode
