Linking Cells to different sheet

[aj_gabby]

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

 

[Guest]

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.