Hello,
I need help with a function that needs to look to left and top. i.e. left column = species of wood Oak, ash, walnut etc... The top has several styles such as crwon, square, oval etc... What I need this proposed formula to do is to return the correct $$ amount from my chart depending on the selections made. I don't know how to do this when multiple criteria exist. I am using 2007, but need it to be compatible with 2003. Thanks for any help!!
Mark Medlin
www.heartlandcustomwood.com
Hi Mark,
This will work in most versions of Excel:
Let's assume your wood species are in column A (A2:A4) and your styles are in row 1 (B1:D1). Your $$ amounts would then be in B2:D4. Let's also assume your selections are in F1 (wood) and F2 (style).
You could use an INDEX/MATCH/MATCH formula to retrieve the correct $ amount based on wood type and style, e.g.
=INDEX($B$2:$D$4,MATCH(F1,$A$2:$A$4,0),MATCH(F2,$B$1:$D$1,0))
Expand it to match your actual data table. Hope that helps!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks