excel & lookup & search

The code below here was written for me by @Fluff some time ago. It's a very wonderful code and I love it. I have added 2 more comboboxes to use as the criteria for doing my filtering but I am stacked with how to get it tweaked. The new comboboxes are: ComboBox3, which will check column Y and...

Hi, I have this function that searches column A for words that I listed in column D and returns "found" or "not found". In the formula below, I only have to search for 4 words in column A so the formula refers to $D$4:$D$8. =IF(SUMPRODUCT(--ISNUMBER(SEARCH($D$4:$D$8,A5)))>0, "found", "not...

How to make Automatic serial number with text ???? Basic = A1+1 =2 Next level : 1) India Combination with text Kindly Help me.....

ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJ1WILDERNESS FIRST AID LEVEL 1& LEVEL 2 PFG 15C02 AUGUST - 06 AUGUST 20212LOCAL0MAXIMUM PAX 203INTERNATIONAL20PROVISIONAL BOOKINGS204OFFICIAL BOOKINGS05CONFIRMED BOOKINGS06AVAILIABLE SPACE07WAITLISTED08NOOUTSTANDING FEES BOOKING STATUS PROVISIONAL OR...

HOW TO USE REFERENCE WITH "RIGHT OR LEFT" FORMULA FUNCTION ???? EXAMPLE: i Try this Reference "AB156480" =+A2 But I need Output : " AB156-480" How it Possible After reference ????

# 1st Condition : MATCH Data 1st "SHEET 1 WITH '"SHEET 2" # 2nd Condition : "SHEET 2" MATCH DATA with other Workbook "SHEET 1" like this BOTH CONDITION MATCH AFTER SHOW ME STATUS " YES / NO " in Worksheet 2 > SHEET 1

In one sheet I have data in one row (Style Number, Column A) which has many duplicates, but every corresponding value of that (each) duplicate value has a unique value (Item Code, Column B). In sheet 2, I have got just Style Number (Column A). How can I match the Column A in both the sheets...

* how to Apply Condition Formating in Particular Cells At a time, (Condition : IF then " Available Qty " <1 to Highlight Cell is RED color). * This condition Apply but Not properly Working , Pleased help to solve this query, I try to use Multiple criteria using this condition formatting.

Hi Peers, I hope you are well? I need your help if possible as I have tried trusted google and I am unable to amend the formula to do what i need. The formula currently works by doing a partial word match when it finds one value in the table. I need your help to amend the formula so where it...

Hi, I have a pivot table which lists football teams down column A (home team) and across row 2 (away team). The values in the pivot table are the game week that the fixtures will be played. From this, I've been able to create an Index Match which summaries the fixtures almost as required. The...

I have an email data where the email column contains duplicate values as I need to interact with a client multiple times. I have one excel tab where I need to match those email id with "Email data" tab and fetch the body column for those matching email id. Attach Excel sheet with name "data...

Hello, I need some help with a query. I have a big employee list (from HR system) showing all the different types changes in the record including changes in weekly working hours, this means some employee could be on the list multiple times (with the same unique employee ID) if they have more...

Hi, I have a dynamic table that I'm trying to sort by the value of the cells (that have duplicate values) in the first column A. I would start of with this: <tbody> Column A Column B Column C 3 cat Cats Rule#1 3 cat Cats Rule#2 3 cat Cats Rule#3 1 dog Dogs Rule#1 1...

I am looking for a more sophisticated query to compare values of a column in a sheet against multiple sheets and if the value is found return values from a different column. I was able to achieve this with iferror and vlookup but i have about 20 sheets to compare values against. Sheet1...

Hello, The first column contains a string of values as mentioned below . In 2nd column, I need to strip out specific info from Col 1 (as mentioned below). I tried using a formula like this - =LOOKUP(MID(AS2,12,3),{"Lar","X-L"," Sma"},{"Large","X-Large","Small"}) , but its not calculating the...

I'm using Index-Match to match Full Names with head count in that party. I have it working but it uses both the structured and explicit cell reference. I can't figure out why when I add a new row in my table, the column with the index-match formula wont populate the last row. This is the formula...

Hi All, I have 2 workbooks; one has got data in multiple tabs and each tab has a different name. The second one has only 2 tabs; second tab has a table in which first 2 columns contain info about the type, tab name. from 3rd column, it will be month wise data like Jan-19, Feb - 19, Mar-19...

Hi, I have an excel sheet where i want to put a mark on. After that i will extract those data on the line to a new sheet. It is difficult to explain but take å look at the file. The number is å productnumber, second is description, third is the product price, the fourth is the number how many...

Hi, I have an excel sheet where i want to put a mark on. After that i will extract those data on the line to a new sheet. It is difficult to explain but take å look at the file. The number is å productnumber, second is description, third is the product price, the fourth is the number how many...

I have a data set where I am trying to create a formula for each work order that does not have a specific task ("Task 5" Below Table) within the work order based on specific customers that must have this task with their work. There will be customers that do not apply and will not need this task...