Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula Question
If I have the below VLOOKUP and the result is $0, how do I had to the
equation to show an actual result of 0? =VLOOKUP(E15,'MLS Listings Pivot'!$A$6:$M$299998,6,FALSE) Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula Question
VLOOKUP() does not "look up" the format. If the cell containing the formula
displays a "$", then: 1. first re-format the cell to General 2. if this does not fix the problem, then VLOOKUP is retrieving a text string with the "$" embedded. In this case use: =SUBSTITUTE(VLOOKUP(E15,'MLS Listings Pivot'!$A$6:$M$299998,6,FALSE),"$","") -- Gary''s Student - gsnu200904 "Brent" wrote: If I have the below VLOOKUP and the result is $0, how do I had to the equation to show an actual result of 0? =VLOOKUP(E15,'MLS Listings Pivot'!$A$6:$M$299998,6,FALSE) Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Newbie Formula Question - how to get formula to repeat in each subsequent row? | New Users to Excel | |||
Formula question | Excel Discussion (Misc queries) | |||
What IF - formula question | Excel Worksheet Functions | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
I get error with "ROWS" in the formula - nested formula question | Excel Worksheet Functions |