software

I wonder if anyone can help me, I have got a spreadsheet where i want to
lookup product information using vlookup, but the problem i am having is that
becuase my product codes are both numeric and letter based it does'nt work
correctly.

I know if i use letter or numbers on there own it works fine but I would
like to use both, is there anyway to accomplish this?

Cheers

Alistaire

That shouldn't be a problem, while the list contains unique values. Try
adding FALSE as the fourth parameter on the VLOOKUP formula, as this will
disable the need of having a sorted list.

Hope this helps,
Miguel

quot;LW_Greeneyquot; wrote:

gt; I wonder if anyone can help me, I have got a spreadsheet where i want to
gt; lookup product information using vlookup, but the problem i am having is that
gt; becuase my product codes are both numeric and letter based it does'nt work
gt; correctly.
gt;
gt; I know if i use letter or numbers on there own it works fine but I would
gt; like to use both, is there anyway to accomplish this?
gt;
gt; Cheers
gt;
gt; Alistaire

Cheera thats did it, i knew it would be something simple!

quot;Miguel Zapicoquot; wrote:

gt; That shouldn't be a problem, while the list contains unique values. Try
gt; adding FALSE as the fourth parameter on the VLOOKUP formula, as this will
gt; disable the need of having a sorted list.
gt;
gt; Hope this helps,
gt; Miguel
gt;
gt; quot;LW_Greeneyquot; wrote:
gt;
gt; gt; I wonder if anyone can help me, I have got a spreadsheet where i want to
gt; gt; lookup product information using vlookup, but the problem i am having is that
gt; gt; becuase my product codes are both numeric and letter based it does'nt work
gt; gt; correctly.
gt; gt;
gt; gt; I know if i use letter or numbers on there own it works fine but I would
gt; gt; like to use both, is there anyway to accomplish this?
gt; gt;
gt; gt; Cheers
gt; gt;
gt; gt; Alistaire