Lookup Function

  • Thread starter Thread starter errocha
  • Start date Start date
E

errocha

I DON'T KNOW WHY SOMETIMES THE FUNCTION LOOKUP WORKS AND SOMETIMES NOT.
DOES THE CELLS FORMAT MATTER?

SOMEBODY CAN HELP ME. E-MAIL ME (e-mail address removed) i CAN SEND A
EXEMPL
 
It's not the format that's really important--it's the underlying value.

If you type 123 in a cell, then change that cell's format to Text, the value in
the cell is still 123 (still numeric). If you format the cell as text first,
then type 123, you'll get the string 123 (like entering '123 with the leading
apostrophe).

This is one of the common problems when the formula looks like it should
work--but doesn't.

Another common problem is when one value has extra leading/trailing/embedded
spaces and the other doesn't.

Debra Dalgleish has some nice notes for getting started with =vlookup() at:
http://www.contextures.com/xlFunctions02.html
 
Back
Top