Linking Cells to different sheet
 

I am a newbie and have very little experience with formulas. I have 2
sheets listed below Sheet AP. is in a formated layout. Sheet BP, which
varies every month, is your traditional style table . Is there a way to
link sheet AP. column V Price to Sheet BP. I need to link them by
product and size. Vlookup I understand can not except 2 values so I
could not get it to work right. Would an array formula work? Any help
would be appreciated.



In sheet: BP, cols A to C, data from row 2 to 300


Product Size Price
A1 B1 C1
A1 B2 C2
A2 B1 C3
A2 B2 C4
etc


And in sheet: AP,

Column A to E, Data on rows Vary

A B C D E
U V
Product Size Price Price

2 A1
3
4
5 C1 D1 ?
6 C2 D2 ?
7 C3 D3 ?
8 C4 D4 ?
9
10
11 A2
12
13
14 etc

Linking Cells to different sheet
 

You can try adding a 'helper' column and inserting your product and size as
one new product. For example, if you had a product called 'Gloves' in two
sizes, small and large, you could add them together in the 'helper' column to
read 'Gloves - Small' and "Gloves - Large.' This can be done with EXCEL's
'concatenate' function. In your case, =Concatenate(A1," - ",B1). You can
then use the concatenated field in your 'vlookup' function.
--
T Tipsy


" wrote:

I am a newbie and have very little experience with formulas. I have 2
sheets listed below Sheet AP. is in a formated layout. Sheet BP, which
varies every month, is your traditional style table . Is there a way to
link sheet AP. column V Price to Sheet BP. I need to link them by
product and size. Vlookup I understand can not except 2 values so I
could not get it to work right. Would an array formula work? Any help
would be appreciated.



In sheet: BP, cols A to C, data from row 2 to 300


Product Size Price
A1 B1 C1
A1 B2 C2
A2 B1 C3
A2 B2 C4
etc


And in sheet: AP,

Column A to E, Data on rows Vary

A B C D E
U V
Product Size Price Price

2 A1
3
4
5 C1 D1 ?
6 C2 D2 ?
7 C3 D3 ?
8 C4 D4 ?
9
10
11 A2
12
13
14 etc