albertocantupomares
New Member
- Joined
- Jun 4, 2021
- Messages
- 5
- Office Version
- 2013
- Platform
- Windows
I was wondering if someone would help me with the following situation,
On another sheet I used Vlookup to get the "Request date" based on the part number, in this case if I use =Vlookup,(1.0617874,A3:J5,7,False) I get "5/31/2021", but I wanted to know how can I get to return the request date, base on the balance, in this case the first "Request Date" value with negative "Balance" (J column). In this example I need the value from G5 because the balance on the same row is the first one with negative number (-31,300).
Also I would appreciate if you could let me know how to ask this kind of question properly, I not sure if I asked this correctly or used more than needed information.
I appreciate the support
On another sheet I used Vlookup to get the "Request date" based on the part number, in this case if I use =Vlookup,(1.0617874,A3:J5,7,False) I get "5/31/2021", but I wanted to know how can I get to return the request date, base on the balance, in this case the first "Request Date" value with negative "Balance" (J column). In this example I need the value from G5 because the balance on the same row is the first one with negative number (-31,300).
Also I would appreciate if you could let me know how to ask this kind of question properly, I not sure if I asked this correctly or used more than needed information.
I appreciate the support