Looking for a possibility of making this formula shorter, any ideas? Thanks
=IF(AND(INDEX('Tab2'!$F:$M,MATCH($F$3,'Tab2'!$J:$J,0),7)=0,INDEX('Tab2'!$F:$M,MATCH($F$3,'Tab2'!$J:$J,0),8)>0),INDEX('Tab2'!$F:$M,MATCH($F$3,'Tab2'!$J:$J,0),1),"")
This formula is producing this
The active cell is A6...
Ok Gang, I have a project with a crazy time crunch and was hoping to have some help on the below.
I have a query of data that has a column with my Lookup Value (Variation 1) and a secondary column with an offsetting value that is backwards (Variation 2).
If you look at the data in column...
Hello!
Here is the logic behind the formula I am searching for.
I have a cell where I enter values A1, say 1 through 10.
I have a master list of numbers 1 through 10, just for reference in the formula. Say B1:B10.
Lets say I enter the number 7 in A1.
I want another cell to then search a...
Hello,
I have two column where I need to perform a match function or formula.
If the first 4 or more characters in both "A" and "B" column matches, I want to see the results in the third column.
For Example:
Column A
<tbody>
MONTEFIORE MEDICAL CENTER-MARGARET KEALY...
Hi, this is my formula;
=IF(ISNA(MATCH(E$2,INDIRECT("'"&$A3&"'!$b$8:$b$11"),0)),0,MATCH(E$2,INDIRECT("'"&$A3&"'!$b$8:$b$11"),0)
i have rows of this formula which i want to put into a table (using excel for mac) but after highlighting and clicking a table template the results all change to...
I'm combining the index and match formula in excel to extract data given a specific reference. The problem however, is that my formula only finds the first listed piece of data rather than all the data that matches the reference.
For example,
I want to find ALL the projects that "Joe" is...
I need to pull data from one sheet and put it into another automatically.
My home sheet has the following data...
Column A: % of project completed
Column B: Status of project (either in progress, on hold, or completed)
Column C: Task Description
Column D: Date project was started
Column E...
Hello, I have been searching for a solution to this with no luck so will explain my problems here:
I have three worksheets relating to three football teams. On each of these worksheets, B2:B19 contains the names of the players and C2:C19 contains the number of goals that each player has...
Hi there,
I have a column containing a large-ish number of cells (column "A"). Each cell contains a concatenation of a dollar figure (can be pos or neg) & a card number & a datetime (MM/DD/YY hh:ss). Example:
<tbody>
-2.23|6202xxxxxxxxxxxx|08/06/13 10:02
</tbody>
I have generally been...
<TBODY>
I want to write a macro that match multiple column and return a value as I show in the table below</SPAN>
Plant </SPAN>
SLOC</SPAN>
Grade</SPAN>
Posting Date</SPAN>
1</SPAN>
555</SPAN>
abc</SPAN>
3</SPAN>
777</SPAN>
def</SPAN>
2</SPAN>
666</SPAN>
jkl</SPAN>...
Hey all, I am trying to get this formula to work properly. I want it to be able to grab the data for the selection of the date that was made. For instance, if I want to show only dates of the driver jake for Jan, then it will only return those dates for that month. Right now, the formula I have...
I came up with this formula to find matches in another file which I cannot edit:
=MATCH("*"&A2&"*",'[F4 2006_ECO Log.xls]ECO Log'!$D:$D,0)
It works fine, except I want to find the last match in column D (there are something like 3 total matches). Match seems to return only the first match. I...
I have a spreadsheet containing 3 columns, First Name, Nickname and Last Name.
In a separate column, I concatenate First Name and Last Name as =PROPER(D2&" "&F2) to return the following:
Jane Doe
It appears that there are many spaces between between First Name and Last Name even...
<colgroup><col span="4"></colgroup><tbody>
Worksheet 1
Posted
Worksheet 2
Worksheet 2
John
?
John
Ben
Matt
?
Mat
Scott
Ben
?
James
?
</tbody>
I need to return a match to worksheet1 if the names exist in either worksheet 2 or worksheet 3. The formula I normally use is...
Column D5:D9999 contains either of 5 values: ABC, MNO, XYZ, #N/A, null
Column E5:E9999 contains either of 4 values: WORKING, NOT WORKING, #N/A, null.
In F5:F9999, I want value of Z1 if column D MATCHES EXACTLY as X1 AND column E MATCHES EXACTLY as Y1 else AB1.
Ex:
Z1=Good, X1=ABC, Y1=WORKING...
Hi Everyone</SPAN></SPAN>
I tried to find similar problem and solutions by searching the older posts in forums but I didn’t find anything so I apologize if this is a repeated question but I would really appreciate any answer and help.</SPAN></SPAN>
1) I have a data set updated every week –...
Hello All,
I have been pulling my hair trying to figure out a formula that would work. Here's my issue: I have a database that keeps track of all material purchase for any specific day. Each material type is assigned a code. I have another worksheet that keeps track of the "selling" price of...
I have a list of Representatives that report to a specific Supervisor who then reports to a specific Manager. (see ex: below)
<TABLE style="WIDTH: 180pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=240><COLGROUP><COL style="WIDTH: 77pt; mso-width-source: userset...
Hi
need a formula for the below example
i need a formula to extract data table as below to match the string in a cell
dec hex
48=0 30=0
49=1 31=1
50=2 32=2
~ ~
57=9 39=9
a1: 5289609277578033121594
a2: dec hex
a3 49 31 (result from...
Hello,
I really need some help here, and I was hoping that someone might be able to answer my formula question please (I've been trying to figure this out for 4 hours, and I know one of you experts will have it solved in 2 minutes :))
Ok, so I have a spreadsheet with this layout (see below)...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.