So I'm trying to limit the number of times each respective project can be repeated based on the table that starts on D18 (the no of available projects table), So this is how the table looks like at the moment:
ABCDEF1Employee NameAttendance...
So I moved the data that I want to use into 1 sheet and I want to compare data on Column 1 with Column B.
I want to find out if the data on Column 1 also exist in Column 2.
I am using "1" for exist, and "0" for not existing.
The problem is, first I tried using my office notebook, but all the...
Hello,
I am doing a vlookup on one column's values which includes multiple data types (dates, number, or #N/A for not available.
The one column's results will either be:
1) a date (formatted MM/DD/YYYY)
2) or it will be a number, positive or negative
3) or it will be not available (#N/A)...
Hi all,
I'm having trouble with the following formula below:
=IF(ISNA(VLOOKUP($C$3,INDIRECT("'"&"*"&$B4&"*"&"'!$A:$A"),1,0)),"NO","YES"))
The indirect function does not seem to work with the vlookup or I am doing it wrong.
Please see below for the excel file...
I have this formula below which works only on a single IF, ISNA & VLOOKUP statement:
=IF(ISNA(VLOOKUP(G770670,Aircrafts!$A$2:$A$1000,1,FALSE)),"Others","CL650")
However, when I expanded it to use multiple ISNA & VLOOKUP, it doesn't work...
Hi guys,
First time posting to a thread like this so apologies if I ask this query in a convoluted manner.
That said, I am currently writing a macro for appending the range of an active worksheet to a .txt file
for further analysis. Whilst I have successfully written this for a test excel...
I want to match the (Sheet1) clent /group to the (LookupTable)name /group and return the corresponding retention.
Formula i am using in Sheet1 cell-Retention Policy but is returning the wrong retention because I have multiple instances of the client/ name...
Here's my formula:
=IFERROR(IF(ISNA(VLOOKUP(B2,'[Master Body Site.xlsx]Sheet1'!$B:$E,'[Master Body Site.xlsx]Sheet1'!$B:$B,FALSE)),"",VLOOKUP(C2,'[Master Body Site.xlsx]Sheet1'!$C:$C,'[Master Body Site.xlsx]Sheet1'!$C:$C+'[Master Body Site.xlsx]Sheet1'!$E:$E,FALSE)),"")
I am trying to look up...
I have a spreadsheet with 10 sheets which will be used for keeping track of jersey number inventory. On the first page I have a table with rows ranging from XS to XL and each cell next to each range has a number representing a jersey number. On the other sheets, which are for each team, I have...
Hi all - so I know how to use the ISNA formula with a Vlookup...BUT...I've tried and tried and can't figure out how to use it if you are using nested IF and VLookup.
Here is my current formula...
Any advice as to why the below formula isn't working? My goal is supposed to return a "1" if the vlookup identifier is not found (ISNA) & add a 1 to the cell IF the identifier is found (IF, +1).
Any advice? I've pasted what I am working on below
=IF(ISNA(VLOOKUP(C[-2],'[PBDunkAcc.xlsx]Merrill...
I have 3 sheets of data. Using IF, VLOOKUP, ISNA/MATCH, I have to create a formula in sheet 3 to find out if the value(A2), exists in either sheet 1, or sheet 2 or both. If the value is in sheet 1 exclusvely I need the formula to generate 1, if the value is in sheet 2 exclusively I need the...
I have a formula that is too long for an excel 2010 cell. I will post it below, but the basic premise is that I have a spreadsheet that has 26 columns and > 8000 rows of data, many of which are n/a errors by design. For each row I want my formula to return the sum of the first 6 columns that...
I'm putting together a workbook where I can load one sheet (raw data) and then in another sheet (product) extract the information I need for a specific format.
The thought process is if the 1st address contains "Box", as in PO Box, then pull back the 2nd address. The criteria I'm using to look...
Good Afternoon,
currently I am using isna and vlookup to generate a report worksheet from a list on different worksheet in the same workbook. essentially, i'm using the "reporting checklist" sheet to input the information, and the "status report" worksheet to neatly present the information...
Hi fellow Excel lovers,
I need help to fix this seemingly simple formula but so far it's eluding me;
=IF(AND (ISNA(R2),ISNA(U2),ISNA(X2)),"Needs Subbing", "Subbed")
I've tried it with =TRUE after each reference and at the end of them and rearranging the brackets structure.
I have a feeling...
Hi Folks
I would appreciate your help with the following.
I am using IFERROR to look up two different tables. If it cannot find it in any table, it returns #N/A
I want to turn that #N/A to "-"
This is the formula:
=IFERROR(VLOOKUP(F12,'Non WE Oppties to include'!B:C,2,FALSE),VLOOKUP(A12,'Non...
Hello!
I'm using a nested IF statement and calculating values based on the data in adjacent cells. I basically want part of my formula to do this check: If this cell isn't equal to #N/A, then display a certain value. Right now, my formula looks like this...
On sheet "Data2" Column A has the name of the Underwriter that saw a case (with repeated values), and column J has the name of the Doctor that the case was referred to. Many cases don't get referred to doctors, so those rows have a #N/A instead of the Doctor's name. (the Doctors names are...
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.