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