1
vote
1answer
50 views

Excel - Lookup to match varying criteria

I have a list of poles, some with more than one test result. I want to find the latest test result for each pole and then return the result. As we know, VLOOKUP only finds the first. I don't want ...
0
votes
1answer
629 views

How to automatically populate a lookup column in Sharepoint 2013

I have 2 Sharepoint lists in SP2013: Errors and Locations. The errors list has a lookup column to the locations list. I need the location information (phone, address, etc) to populate automatically ...
1
vote
2answers
65 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 ...
0
votes
0answers
32 views

Select column without cell adjacent in Excel for Mac

I want to select the entire column to the left without the cell adjacent to the left to run a fuzzy-lookup. Of course I'd like to make that expandable, so I don't have to make it by hand. Here is the ...
0
votes
3answers
216 views

Lookup range of words in range of sentences

Based on the following example: I want to look up for words from the $D$2:$D$6 range in sentences from the $A$2:$A$8 range and use the value from the side column (here Tag). So far I'm doing this: ...
1
vote
1answer
941 views

MS Excel 2010: VLOOKUP not working right?

Here's the data that I have on the "Components" sheet (B4:E13): Component 1 a Form Low Component 2 a Form Low Component 3 a Form Medium Component 4 a ...