Im writing a new pricelist, and need to be able to find an exact height and width for a door within the pricelist
See pic attached for a look at the pricelist and more details.
Thx in advance for any help offered.
Gordon
Im writing a new pricelist, and need to be able to find an exact height and width for a door within the pricelist
See pic attached for a look at the pricelist and more details.
Thx in advance for any help offered.
Gordon
Last edited by ministerofdeath; 03-30-2008 at 02:04 AM.
Set the last parameter for VLOOKUP to TRUE. This will pick up the next bigger size from the table.
Ministerofdeath, Welcome to excel forum!, if you must cross post in other forums please supply the links ( you should do this in all forums you have posted in) as i have done here with this particular one.
http://www.mrexcel.com/forum/showthread.php?t=311564
People who help on these forums often frequent dozens of other forums and if they see a cross post without the link you are not likely to get much help!
Not all forums are the same - seek and you shall find
Hello
Check out if attached filr help u. Be sure that Height and Width are arranged in descending order.
See the attachedOriginally Posted by ministerofdeath
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks