Get instant live expert help on vlookup closest match
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
A continuation with an expert for my filter page column with Closest Expiration
Solved by E. D. in 21 mins
Is there a way to have list in 2 columns be sorted out by another 2 column group, and have the closest greater value return as a result? Similar to the VLOOKUP or MIN function. I want to keep the numbers in each group, together. This is for finding the closest aspect ratio to a tv signal. Example: my resolution is 500x320, so the closest resolution out of a list would be 1280x720. I don't want to search each column individually, but rather as a group. Thanks :)
Solved by A. A. in 17 mins
Match a column to two similar columns, vlookup/match?
Solved by D. J. in 21 mins
Complicated formula possibly using match and vlookup?
Solved by C. Y. in 14 mins
hi - I have 2 tables and I am basically trying to do a vlookup off of two criteria,one text (Col A) and one date(Col B). Col A needs an exact match and Col B needs a closest match without going over. Table 1 Col A Col B Col C Fruit Date Rate Apples 2/15/18 ? Table 2 Col A Col B Col C Fruit Date Rate Apples 2/16/18 1.5 Apples 2/10/18 2.6 the Answer should by 2.6. Is this possible?
Solved by T. E. in 15 mins