Re: VLOOKUP WITH ALPHA NUMERIC

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks! I'll try it next time. VG

"arno" wrote:

> Hi,
>
> now that you know that your vanilla fills up fields with blanks and
> that the size is 6 characters you know what to do in your vlookup: fill
> up your match kriteria (in a1) with blanks like:
>
> =vlookup(left(a1&" ", 6), table, column, false)
>
> (there's a repeat function that could repeat a " " 6 times, I do not
> recall the name in english right now...)
>
> you do not need to remove the blanks from your csv-file, so don't do
> it, leave your data what it is.
>
> arno
>
> ps. knowing the field descriptions of tables make the difference
>
>
.

Relevant Pages

  • Re: VLOOKUP WITH ALPHA NUMERIC
    ... now that you know that your vanilla fills up fields with blanks and ... that the size is 6 characters you know what to do in your vlookup: ... up your match kriteria with blanks like: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: export numeric field right alligned
    ... Salad wrote: ... Arno R ... blanks with spaces. ... Can I do this using the format function? ...
    (comp.databases.ms-access)
  • Re: export numeric field right alligned
    ... Arno R ... blanks with spaces. ... blanks with zeros. ... Can I do this using the format function? ...
    (comp.databases.ms-access)
  • Re: export numeric field right alligned
    ... Don't fill the leading blanks with zero's but with spaces... ... Arno R ... blanks with zeros. ... Can I do this using the format function? ...
    (comp.databases.ms-access)
  • Re: What is a field of all blanks?
    ... leading blanks are not significant. ... > required by the standard, ... > constitutes the field is all 15 characters, ... I see no digits before the exponent in this field. ...
    (comp.lang.fortran)