Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
@vlookup returns the formula instead of the value - why?
I am using an @vlookup to return a "Y" or an "X" value back. When I try to
change this function, instead of getting a "Y", "X" or blank cell, the formula is what shows in my cell vs the text I want returned. When I originally set up the fx in this spreadsheet, it was fine. It wasn't until I needed to edit each month that I have this problem. Even it I delete the fx and re enter, I still get the formula returnevs the value. See Below what comes back in my cell. The Y's are correct. Not sure why the formula is returned vs a Y, N or blank cell. Not sure if there is something I need to turn off or on. I looked in the tools - options and did not see anything. =VLOOKUP($B15,'Station Rep Guide'!$C$3:$k$1089,8,FALSE) Y Y Y |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FORMULA RETURNS #VALUE WHEN PRESCEDENT WORKBOOK CLOSED | Excel Discussion (Misc queries) | |||
Formula to sum every 4th cell returns #DIV/0! error in some column | Excel Worksheet Functions | |||
IF Function returns result of formula | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |