I am having trouble coming up with a formula to extract pricing based off a Description and size. In Sheet 4 Column B I have my description and Columns C:G are the sizes i want the pricing to go to based off the description. The pricing is in sheet 2 I attached the file Book3.xlsx. Any help would be great.
Hello TheTallOne and Welcome to Excel Forum.
I believe that the following will give you what you asked for.
1) Fill in the blank cells in column A of sheet 2 using the directions found in the video from this tutorial (under the section heading "Video: Fill Blank Cells Manually").
2) Put spaces in cell C1 on sheet 4 so that S - XL matches the format of the sizes in column C on sheet 2.
3) Populate the range C2:G15 on sheet 4 using the following array entered formula:Formula:
Please Login or Register to view this content.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
or, with a slight modification, using an ordinary formula (no need for array entry):
=IFERROR(INDEX(Sheet2!$D$2:$D$155,MATCH(1,INDEX((Sheet2!$A$2:$A$155=$B2)*(Sheet2!$C$2:$C$155=C$1),),0)),"")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
No consideration of Colour????
I suggest Pricing table format would be better if the format was the same as your output, with "Colour" column added.
Duhhh. well spotted JT.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks