Simple problem

Hi all

I am struggling to understand how to get a formula to work and have tried to read all the tips but have just confused myself more with all the different formulas.If anyone can guide me in the correct direction as to what formula in excel i should use thanking you in advance.

=LOOKUP(A1,AE1:AE1000,AF1:AF1000)

In column A1-A1000 I have a list of product codes and i would past the new supplier price list in column AE and in column AF is the new cost price.

What i am trying to do is tell it to find the product code xtr200 in the column AE and return the value next to it 200 which is the new cost price.

I got the formula to work but the problem is if it does not find the product code if would just find a value above and return any cost value.

I just need it to return "no value" if it can not find the product code

Any help would be appreciated

=VLOOKUP(A1,AE1:AF1000,2,FALSE)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"excelnovice1" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi all
>
> I am struggling to understand how to get a formula to work and have
> tried to read all the tips but have just confused myself more with all
> the different formulas.If anyone can guide me in the correct direction
> as to what formula in excel i should use thanking you in advance.
>
> =LOOKUP(A1,AE1:AE1000,AF1:AF1000)
>
> In column A1-A1000 I have a list of product codes and i would past the
> new supplier price list in column AE and in column AF is the new cost
> price.
>
> What i am trying to do is tell it to find the product code xtr200 in
> the column AE and return the value next to it 200 which is the new cost
> price.
>
> I got the formula to work but the problem is if it does not find the
> product code if would just find a value above and return any cost
> value.
>
> I just need it to return "no value" if it can not find the product
> code
>
> Any help would be appreciated
>
>
> --
> excelnovice1
> ------------------------------------------------------------------------
> excelnovice1's Profile:
http://www.excelforum.com/member.php...o&userid=35891
> View this thread: http://www.excelforum.com/showthread...hreadid=556813
>

I wish i could do something for you this simple formula has saved me many hours of work Thanks Again

You just did <g>

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"excelnovice1" <[email protected]>
wrote in message
news:[email protected]...
>
> I wish i could do something for you this simple formula has saved me
> many hours of work Thanks Again
>
>
> --
> excelnovice1
> ------------------------------------------------------------------------
> excelnovice1's Profile:
http://www.excelforum.com/member.php...o&userid=35891
> View this thread: http://www.excelforum.com/showthread...hreadid=556813
>