vlookup

  • Thread starter VLOOKUP - Contains a constant???
  • Start date
V

VLOOKUP - Contains a constant???

Ok...I'm new with the VLOOKUP function so this is probably pretty easy for
most of you. I've created a VLOOKUP that's not working and it says the
probably is the cell contains a "contstant"...what is that, and what does
that mean and how do I fix it?

VLOOKUP(I2,TAX_ID,14,FALSE) I want the cell to look at column I compare
with the TAX ID column and return the value in column 14, only when an exact
match.

Thanks!
 
A

Alan Beban

VLOOKUP said:
Ok...I'm new with the VLOOKUP function so this is probably pretty easy for
most of you. I've created a VLOOKUP that's not working and it says the
probably is the cell contains a "contstant"...what is that, and what does
that mean and how do I fix it?

VLOOKUP(I2,TAX_ID,14,FALSE) I want the cell to look at column I compare
with the TAX ID column and return the value in column 14, only when an exact
match.

Thanks!
Click to expand...

What's the address of the range "TAX_ID"?

Alan Beban
 
Top