VLOOKUP

  • Thread starter Thread starter Brenda Hutton
  • Start date Start date
B

Brenda Hutton

If the Lookup Value from the worksheet cell is not found in the Table Array,
we are getting a result of one. We would expect to get a #N/A, a blank
cell, a zero maybe; anything except the valid value of one. How do we
prevent this? TIA
 
Back
Top