Get instant live Excel expert help with INDEX MATCH Function

I need to match the first name and last name fields, and index match on the ID field. There are 2 seperate sheets here.

I am trying to perform an INDEX MATCH function with text data. Basically, I am trying to match a text field in one table, with a text field in another table, to pull out its corresponding identity code. I keep getting an N/A error, when when I perform a MATCH function itself, but the text is clearly present in the lookup table.

I need help generating a formula for a multi sheet workbook. I need to use a Index match match to locate a value then offset over a couple rows to pull that number into another sheet

This is a truck driver roster, I would like to find todays date on the horizontal across the top, then in that column find a specific truck eg "042 DS" then to return the driver of that truck on the left hand side of the table. I've tried Index Match, Ive tried Index Match Match but I cant work it out. Please help, its doing my head in... =INDEX(A15:A29,MATCH(TODAY(),B12:NA12,0),MATCH("024 DS",B15:NA29,0))

trying to create a spreadsheet for invoicing purposes that uses a index match lookup function

I would like to look up a value based on certain criteria. I think an index match would work, but it has to match two cells.

index match returning duplicates to my search area, dont think im setting the new row to search right after it finds a match in the array, like match on line 3 , search results show 3 line 3s in search area instead of 1.

How do I use index match when my lookup value is a formula?

I am trying to write an Index Match formula that will return all of the employees at a particular company. I am matching on CompanyName1 and want the results to return ContactFirstName, ContactLastName, and ContactEmail in separate columns. Attached is an example of the workbook and how I want the results to look.

I need help setting up an array function for Index Match, I have data I paste into excel, and sometimes it has multiple entries for the same item, I need these items summed. I am currently using Index Match in my table on a different sheet, but that only pulls up the first occurrence of the value I am matching.