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!
|