Formula Question

  • Thread starter Thread starter Brent
  • Start date Start date
B

Brent

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!
 
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),"$","")
 
Back
Top