3k item#'s, 6 design choices each. Formula to input correct cost when both varibles known.

[jondon]

Good afternoon everyone. I created a small sheet similar to the one I'm working on. It has two pages. One to use, and one for data. When I put in an item number I would like the cost to automatically populate using the item number and design choice for that column (cells D11 or I11). Please and Thanks

[Pete_UK]

Put this formula in E13:

=IFERROR(VLOOKUP(C13,data!$A$3:$H$21,MATCH($D$11,data!$A$2:$H$2,0),0),"")

then copy down. Put this formula in J13:

=IFERROR(VLOOKUP(H13,data!$A$3:$H$21,MATCH($I$11,data!$A$2:$H$2,0),0),"")

then copy down.

Hope this helps.

Pete

[jondon]

Thank Very Much. You're awesome!
Will mark as solved.

[Pete_UK]

Will mark as solved.

You could also click on the Add Reputation button at the bottom of Post #2.

Pete