I have been racking my brains with this all afternoon, and have searched
to no avail... I'm sure there is an easy solution!

I am trying to find a formula for an order form, so I can enter the
code in column A, and then have the name of the actual product appear
in column B. So for example if I enter "BL" in column A, I'd like "Blue
Loop" to appear in column B.

Thanks :)


--
lolligirl
------------------------------------------------------------------------
lolligirl's Profile: http://www.excelforum.com/member.php...o&userid=19987
View this thread: http://www.excelforum.com/showthread...hreadid=345760

Hi, lolligirl;
Create a lookup table on another sheet (say Sheet2) with your codes in
column A, and your product names in column B. (You could also put unit prices
in column C, and so on). If your lookup table covers A1:C9, and your code is
entered in A1 on your order form, your formula in B1 would be:
=VLOOKUP(A1,Sheet2!$A$1:$C$9,2,FALSE)
This looks in the first column of your lookup table to find a match to A1 on
your oder form and then returns the corresponding value from the second
column in your lookup table. =VLOOKUP(A1,Sheet2!$A$1:$C$9,3,FALSE) would
return results from column 3 (unit price) in the table and so on.
Regards,
Ian.


"lolligirl" wrote:


I have been racking my brains with this all afternoon, and have searched
to no avail... I'm sure there is an easy solution!

I am trying to find a formula for an order form, so I can enter the
code in column A, and then have the name of the actual product appear
in column B. So for example if I enter "BL" in column A, I'd like "Blue
Loop" to appear in column B.

Thanks :)


--
lolligirl
------------------------------------------------------------------------
lolligirl's Profile: http://www.excelforum.com/member.php...o&userid=19987
View this thread: http://www.excelforum.com/showthread...hreadid=345760

Hi Lolligirl
I have this would you like me to send it to you
send me your email address
peterm

"lolligirl" wrote:


I have been racking my brains with this all afternoon, and have searched
to no avail... I'm sure there is an easy solution!

I am trying to find a formula for an order form, so I can enter the
code in column A, and then have the name of the actual product appear
in column B. So for example if I enter "BL" in column A, I'd like "Blue
Loop" to appear in column B.

Thanks :)


--
lolligirl
------------------------------------------------------------------------
lolligirl's Profile: http://www.excelforum.com/member.php...o&userid=19987
View this thread: http://www.excelforum.com/showthread...hreadid=345760