Questions about index-match
Read more about index-match
python (65.2k questions)
javascript (44.3k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (13k questions)
Is there a function for Excel 2019 like index match or vlookup to find a value in a row added cross sheet?
I am running a report on Excel 2019 which has 2 sheets, and I want to automate the value in the field called Status in the sheet2 with the new status on sheet1 where a new row was added for the same i...
David Knight
Votes: 0
Answers: 2
Finding duplicates across range and summing it up
I have a list of agents who are working on OT, but the challenge is that they have 2 entries for OT per day, and when i need to work on this data with another sheet i have to sort out the data and rem...
egflame
Votes: 0
Answers: 1
time in position - excel dates
given the following excel table
I'm trying to add a column with the number of days in a position, my problem is that the 'starting date' for an employee (column b) is the same. This is why I'm struggl...
Merdok
Votes: 0
Answers: 2
Tricky XLOOKUP or Index Match across multiple columns in Excel
I wish to populate 'owned' column tab1 with values from tab2 'assigned' column
IF
tab2 'name2' column matches w tab1 'name' column
Data
tab1
A B
owned name
aa11
bb22
...
Lynn
Votes: 0
Answers: 0