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

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

--
HTH

Bob Phillips

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

"excelnovice1"
wrote in message
news:excelnovice1.2a5o14_1151570742.0425@excelforu m-nospam.com...

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


--
excelnovice1
------------------------------------------------------------------------
excelnovice1's Profile: http://www.excelforum.com/member.php...o&userid=35891
View this thread: http://www.excelforum.com/showthread...hreadid=556813

You just did <g

--
HTH

Bob Phillips

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

"excelnovice1"
wrote in message
news:excelnovice1.2a5qko_1151574004.7694@excelforu m-nospam.com...

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