vlookup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Searching the formula (not the value) for a text string 1
Need VLOOKUP to Work Two Ways 0
VLookup vs. Match/Index 6
Vlookups not working 2
Dynamic col_index_num in VLOOKUP? 5
Excel IF statement with vlookup 2
Vlookup and return sheet name also 2
Help with Vlookup and MAX functions 4

Back
Top