Re: vLookup Help

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi Grant,

Unfortunately you don't tell is what "one" is and what "the other".
Let's assume it is the search key (the 1st argument to the Lookup function) which is a number, and the table keys are text.
Replace Your Search Key with:
TEXT(YourSearchKey,"#")

BTW look at the more uptodate versions of this function: VLOOKUP() and, to a lesser extent, HLOOKUP()

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Grant" <dayton500@xxxxxxxxxxx> wrote in message news:eRE%23RM2AHHA.4060@xxxxxxxxxxxxxxxxxxxxxxx
|I am sure that I read the solution to this problem b4 but can not locate the
| answer. My example is my Lookup_value is 24208853. This number apperars in
| the Table_array but I get #N/A returned. The reason is one is formatted as
| general and the other is formatted as text. How can I get around this? I do
| not have the option of getting specifying the format for the data.
|
| T.I.A.
|
| Grant
|
|


.

Relevant Pages

  • If Function true value in Red
    ... I have written an IF function where the true value is a Lookup function. ... would like either the cell background or the text to format in Red if the ... Lookup portion of the IF function is utilized (this would be the value if ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Changing the shape colour from Custom properties
    ... I managed to use the LOOKUP function up to that it changes the color value ... Under Line Format, LineColor, I need the formula to hook up the ...
    (microsoft.public.visio)
  • Re: Losing Cell Format In Lookup Function
    ... In Excel 2007 you can do this with conditional formatting. ... in List A, the function only returns the value and NOT the format, which is ... Is there a way for the lookup function to return both the value and format ...
    (microsoft.public.excel.worksheet.functions)
  • Lookup formats
    ... This may be a long shot, ... possible for the format of the "looked up" cell to be carried across? ... lookup function be made to include this colour coding? ...
    (microsoft.public.excel.misc)
  • RE: Pivot table field settings
    ... It sounds like what you want is a lookup function, but it is hard for me to ... > Instead of displaying the sum, count or average of the data, I would like ... > is in text format like SocialScience456, ... > in TeacherName and the column is in Period#. ...
    (microsoft.public.excel.programming)