find & return

I have a list, in Column A, of 900 customer codes. Examples are AFP, AU3, NKD, YM2, JWW etc... They could be anything, but are always either 2 or 3 characters. In Column B and Column C I have those codes broken down into the "First two characters"(column B) and then the "Last two...

Hello! I have two sheets. Sheet 1(NOM ROLL) has with id numbers in col A and spaces in col E and F. Sheet 2(JMES) has a subset of the id numbers in col B and in Cols J & k, strings. I need to find the matching ids in (s1)A and (s2)B and where they match, copy in (s2)J&K into (s1) E&F. Below...

=IF(ISNA(VLOOKUP(B9,$F$2:$F$15720,1,FALSE)) = TRUE, " ", D9) Buenos días, me uno a este foro porque estuve buscando solución a un problema que no logro resolver,ya busque en Internet y en este foro y no encontré algo que me pudiera ayudar por este post. Lo que pasa es lo siguiente: Tengo...

Hi, I've multiple entries in column A, which are Text/Number/Character strings and i've created unique set and placed in a row to search the same text in the Column A and return the value at the end of the string. I know it is difficult to explain, here is what is appear like Column A Customer...

Hey Guys, I am looking to find the Max Alphanumeric Serial Number that is in a column and increment by 1! I have code that finds the last "Sequential" serial number in the column and it increments by 1 but unfortunately all my Serial numbers are NOT Sequential in the column! Can someone please...

ok I have searched everywhere but cannot solve this problem I've been dealing with for over half a year. I have an excel sheet with a daily schedule of items. equipment id is the left column and dates across the third row. I need to find text in the sheet and get the date it falls under, but...

I used Excel to figure the payroll commission that we pay our salespeople. I have an individual worksheet for each person that totals in the same manner for everyone. At the end, I have a page that totals all of the individual totals. We use a "draw system" for paying our employees, which...

Hi Everyone, Here's what the data looks like that I'm working with (within a single cell; A1): Eric (2) Dana (3) Tina (4) I am looking for a formula that can extract the number within each pair of parentheses and place each number in a different cell: 2 in cell B1, 3 in cell B2, and 4 in cell...

Hi Guys, I have been wrecking my head with the following! hope you guys can help? I am trying to look for some VBA Code so that I can search multiple values in Column "A" based on the criteria in Textbox1 and SUM up the corresponding values in Column "B" based of course on the criteria in...

Hi, i am trying to find a value in an array based on partial input from a user. The user will enter the last four digits of a number. then the fomula should find the number in a list and return that complete number i will explain using example. here is the list of numbers (array): <TBODY>...

Hey all! I need to search a list in column B of 500 records to find specific words such as"ABC2000000000" The text will always begin with "ABC................." and I would like to extract this whole world from the text string into a new column. This is not always in the middle or beginning or...

Hello I was trying to google it and checked on forums, but couldnt successfully found any solution to my problem. I have a list of names in coloum D of a worksheet called "Trial", I have another worksheets called "Usage" with this list. I need a macro which can search the name written in Trial...

Say I have these two lines in Column A: 3051S2TG4A2A11X5AWA3WK1I5A1140 3051S2LD2AA1A1030DFF71CA00 I need to be able to have a formula in Column B that Finds the letter "A" when it is followed by four numbers, and then return "A and the 4 numbers." So for the first line, the result in Column...

Hi Guys, I am looking for VBA code to search for multiple entries and if those multiple entries are "True" then the code will pass the Answer in a Textbox as "Hired" or "Available" Basically I am trying to develop a little program for Hat Hire whereby if I enter the Date of when the customer...

Hi Guys, I am looking for VBA code to search for multiple entries and if those multiple entries are "True" then the code will pass the Answer in a Textbox as "Hired" or "Available" Basically I am trying to develop a little program for Hat Hire whereby if I enter the Date of when the customer...

OK - I need help creating / populating a table. I can talk it through, but can't figure out how to work the formula... In the table below, the left half is the data I currently have. I need to wiggle it around to look like J10. Basically, I need a formula that I can plug into every cell in...

Hello I am having a challenge with this one and have spent over 4 hours on the net attempting to find a solution... none seem to work for me. I have column A with the company name, Column B to G are new equipment and H to AN are service. (I am not VBA Savy sorry) The challenge...

Hi, i have data spread across 76Rx68C - this table is raw data with no logic to placement of values within in in another sheet i have one row of values i need to know if each of these values appear in the data spread. - a simple YES / NO would suffice - i dont need to know where exactly are...

Hi Guys , I am struggling to separate this worksheet in my work place . i have thousand cell with this type and i would like to separate them Name (a cell ) Badrol Zaman bin Abdul Samad Nurhayati Sholeha binti Abdur Rahem real name ( b cell )should be : Badrol Zaman Nurhayati Sholeha...

Hi Folks, I want to use Excel to perform some types of text search and do display the results as described below: For example, I have an excel table with two columns (A, and B). column A contains a list of book names, and cells in column B are synopsis of the respective books (which is a text...