lookup and match

Hello! I have two sheets within a spreadsheet: Report and Rates. Report contains an account listing with a concatenated name in column S and a start date in column H. Within Rates I have triplicate rows containing the same concatenated name for each time frame in column F. Column G of the sheet...

Hello Gurus, Do you have any thoughts on how to code this scenario (see image below)? I was thinking of using Cell I2 in SHEET 1 as reference in order to pull the info from the different sheets (specific Data sheet and Others sheet). Appreciate the thoughts. :)

We are using Ethernet cabling for a non-Ethernet application, and crimping the wires into a giant 96-pin connector. The internal wires in a standard Ethernet cable are colored Orange/White, Orange, Green/White, etc., where each Color and Color/White pair carries a differential signal, so each...

C2:C7 has single non-sequential numbers and B2:B7 has multiple numbers separated by commas in each cell. I want to match the C2 numbers in B2:B7 and get the output of the corresponding matching number in D2. Can anyone help me formulate this? Thanks

Hi all, What will be the formula if I key in information in table 1 and it auto appear in the table 2 (meeting planner) above. Thank you. Is it combination of V-Lookup + H-Lookup? I was unable to set the formula. Kindly need expert to teach me. Thanks a lot.

Hi, I have a set of data with a non-unique numerical ID. However, the column "Name" can be considered unique. Please see below. The cell reference of "Order ID" is B1 and the bottom right cell is G15. Order ID Name Poule Number Victories Prop Indicator 845.3333333 James 1 5 0.83 12 497...

Greetings - I have tried varations of INDEX and MATCH and various LOOKUPS, but I do not seem to be able to find the correct syntax to solve my problem. Any help would be greatly appreciated, thank you! I have 10 columns. In row CL1, if there is any data, the data starts in CL1 and cells to...

Hello, I am looking for a way, I've been kicking around INDEX MATCH, to create a formula that will accomplish what I have in Column P (manually) The Order ID and Invoice Number are identical, however, they are not unique. I know index match can do this, frozen to a lookup value, but is there...

Greetings all! Trying to workout a situation that I'm stumped on where I need a lookup style function to return the name of the column when there are 2 or 3 digits within that column are the same. I need the different LookupReason's to reference the corresponding Large value and then recall the...

Hi All, Firstly, I'm sorry for cross-posting, but please I want help for my problem I have 2 excel files, 1 and 2 (see attached files) In 1, there are multiple sheets, named according to group names for students, and in each sheet, there are student names and their group names (two columns...

I have a workbook with two worksheets. on the first sheet, I want to use years of service and category to then derive the salary from the second worksheet. I believe that this will be a combined formula for lookup and index/match. Unfortunately, this is getting way beyond my abilities...

Hey folks, I searched for an answer on this, but maybe didn't know how to word it properly. In my case below, I'm trying to create a rule set (Green table) when if the value is contained in the "Description" column of the main table, then a lookup will auto-classify the row based on the type. I...

I have a spreadsheet that has a bunch of exchange rates with dates in Column A (most recent date at the top) and exchange rates in the rest of the columns. I previously used INDEX/MATCH to look up exchange rates on specific dates or the average of exchange rates over a date range...

I'm curious about the best way to search a cell, and if a specific string is found then return a specific value based on an array of outputs. Here's the current formula that I'm trying and I'm not sure what the issue is (I'm on Excel 2019 for Mac if that is a potential issue)...

I want to mach 2 columns A is the unique list of name's static B is unformatted console list In C want Names that matches,and very close and higher/approximate possibile name to get captured In D column is any way to put an remark 100%,90%,80%,.....no match...

I need help building a lookup function. I have 4 columns. Column A is the number value I want to lookup on column C to find an exact match. When found, I want the text value on column D to be placed on Column B. Any help would be greatly appreciated.

Good day I have a main sheet where I update with wildlife breeding information. We have several fathers (each with their own sheet based on their names) and each father have several offspring past and yet to be born. Each offspring gets a tag number, gender, date etc. All this information is...

Hi, I need a formula that can meet below statement: If the value is not found in specific range, then try to find it in another range, if not found in both ranges, then NA. Below is a sample data for more illustration: If the ID is found in Range 1, then Range 1, if not found, then try to find...

Happy day Below is the data of my work. Data size will be variable.i need to format the rows and columns as per the values which are intersect. Rows' colors and formats of column C as shown in the left are as default color and format of the respective same rows in specified working range and...

Please sir / Madam, I need urgent help with the below; I have two tables. I want to be able to search for the ID from a lookup table and return the one that closely matches the date and time of the main table. Please see sample tables below; Main table ID Date time Vlookup Value 1035...