I put in a new table in E16:K23 then you can use this formula in P2 copied down
=IF(N2>40,INDEX(G$22:K$23,
You get #N/A error in P13 because size doesn't fall in any of the ranges
see attached
regards, barry
27323353.xlsx
Title | # Comments | Views | Activity |
---|---|---|---|
Importing csv to excel - text formating | 14 | 23 | |
In Excel 2007, how do I insert a blank space between two dynamic values in a cell? | 3 | 10 | |
3rd level dependant list | 4 | 33 | |
EXCEL formula help required | 3 | 0 |
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
17 Experts available now in Live!