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!

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!