vlookup duplicates

Hello all, I am using below formula to lookup duplicate values but not getting the result need help in this EFGHI1A1 AmountA1 DateB1 AmountDate2-5448.2207/16/2018-5,448.2205/29/2018Not Getting This I need Both this and next...

I hope I'm able to explain this well. I'm working on a loan report that shows current lending exposure by customer. I am not able to edit the report query at all, so all manipulation has to be done in excel. Because of the nature of the report (some loans are guaranteed by multiple people), each...

Hello, I have been searching all day to find an appropriate formula (I assume INDEX) to help me with my current issue with no luck. I am on a strict deadline so if anyone can help me that would be great. What I am trying to do is re-work my vlookup formula to allow for multiple "hits" (I will...

I have a sheet with data similar to the following. (Sheet1) ........Col1 .................Col2 1 25145 Allure........ =VLOOKUP(A1,Sheet2!$A$1:$B$5,2) 2 25146 Allure 3 25147 Oak...

Hi, So I know that with VLookup, if your Lookup Value occurs more than once in a column, it will only return the value of the first one found. Is there a way around that, or another formula I can use, without having to figure out loops and macros? Let me explain what I want to do: I have a...