1
vote
2answers
68 views

Formula to search highest value related to a near match reference

I have a list of neutral references which change as per the date so What I am looking for is a formula that will search Product and return the latest date. e.g., A B ...
1
vote
1answer
92 views

Excel Lookup Not returning Proper Result

I have a simple lookup function, which I am using in place of a Switch Case statement. Following is what I am trying to accomplish: switch(F5){ case "apple": return "1"; break; ...
0
votes
1answer
259 views

Lookup is failing to accurately use the lookup value

I am using two Excel workbooks; one is the backend for the other. In Book 1, there are sheets sheets with a $Timeline, $ClientInfo, and $VendorInfo. Book 2 is meant to be a summary record of different ...
0
votes
2answers
4k views

Checking if any cell in a column of strings on one worksheet is contained in a column of strings in another worksheet

I have a column of strings in an Excel worksheet. I'm looking for a way to write a worksheet function (not VBA) that will allow me to tell, for each cell, if the value of the cell is contained in a ...