LinkBack URL
About LinkBacks
Hi guys,
I need a way to look up the price if I input width and drop. Attached is a sample file. Sample.xlsx
If I input a value for width and drop that is not present in the table, is there a way to return the next amount instead?
Thank you!
INDEX & MATCH for approximate matches or combine VLOOKUP & HLOOKUP
Hi guys,
I need a way to look up the price if I input width and drop. Attached is a sample file. Sample.xlsx
If I input a value for width and drop that is not present in the table, is there a way to return the next amount instead?
Thank you!
Last edited by michaljireht; 12-01-2014 at 08:12 PM.
You can attach files directly to one of your posts - no need to use a separate 3rd party site. It would be better to attach the Excel workbook, rather than a picture - the FAQ describes how to.
Pete
Edited the first post and added attachment. Thanks!
Put this formula in H20:
=INDEX($B$2:$AI$16,IF(H19<$A$2,0,MATCH(H19,$A$2:$A$16))+(COUNTIF($A$2:$A$16,H19)=0),IF(H18<$B$1,0,MATCH(H18,$B$1:$AI$1))+(COUNTIF($B$1:$AI$1,H18)=0))
Then you can just copy it into I20.
Hope this helps.
Pete
It worked! Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks