Re: Greater Than or Equal To Lookup Formula
Thank You, Azumi! It works like a charm. You are a genius, and I am very appreciative.
Have a wonderful evening!!!
Re: Greater Than or Equal To Lookup Formula
Thank You, Azumi! It works like a charm. You are a genius, and I am very appreciative.
Have a wonderful evening!!!
Re: Greater Than or Equal To Lookup Formula
Azumi - Thank you for responding to my post again. I really appreciate your help. The formula for Sheet 1 cells C2:C4 works perfectly. However, I should have explained that I need the formula for Sheet 1 cells D2:D4 to only return the rate =>95%, if the count is >20 in cell C2:C4. Can you please modify and resend? Thanks!
[TABLE="width: 349"]
I am new at advanced formulas and would appreciate your help. I need a formula to extract the count and percentage from Sheet 2 (C2:C4 >=20 and D2:D4 >=95%) and place results in Sheet 1 cells C2:C4 and cells D2:D4. Please refer to sample attachment.
Thank you for your assistance with this problem!
[/TABLE]
Re: remove pop attached to ozgrid http://09.ptp22.com/
Yes, I am receiving it too. I am getting a message that the website wants to run the following add-on: Microsoft (R) Dynamic HTML Editing Control from Microsoft Corporation. Then several pop ups with a message User Blocked. I started receiving this message and popups yesterday.
Re: Vlookup to return one value from multiple columns
Azumi -
Thanks so much for responding to my post. The formula works perfectly now. I appreciate you and Mr. Mika working with me on this problem. I am new at advanced Excel formulas, and I will continue to take additional course. However, this is a great forum for getting help from experts like you and Mr. Mika.
Have a great day!!
Re: Vlookup to return one value from multiple columns
Quote from Robert Mika;685805forum.ozgrid.com/index.php?attachment/56605/
Please see attached
Thank you so much for response. It appears that on Sheet 1, the correct data is reflected for 123-D John Doe. However, for Employee ID, 456-D, Sheet 1 shows 256-D Mary Smith instead of 456-D-Mary Poppins from Sheet 2, D11. I need this formula for a report that is due tomorrow.
Please refer to the attachment.
Thank you advance for your help with this problem.
Re: Vlookup to return one value from multiple columns
Mr. Mika -
I still need help with this formula. Please refer to last post with attachment. Need resolution as soon as possible. Thanks so much for your help!
Re: Vlookup to return one value from multiple columns
Quote from Robert Mika;685001forum.ozgrid.com/index.php?attachment/56494/
Please see attached
I apologize for the delay in responding to your post. Can you please modify the formulas to return in cells B11 and B12 on Sheet 1 the Employee ID-Name (e.g. 123-D-John Doe) from column 1 of Sheet 2 instead of the state in column 2. Please refer to the attachment. I think that should do it.
I am new at advanced Excel formulas, and I truly appreciate you responding to my post.
Re: Vlookup to return one value from multiple columns
Quote from azumi;684869Check the files attach bro.. I hope this is what u looking for...
Asumi -
Thank you for your response to my post. Unfortunately, I attached the wrong sample worksheet. My apologies. Can you please take a look at this attachment and provide the formula to return the employee name? There are 3 separate pivot tables on one worksheet. I have made some notes on the worksheet for further clarification. I appreciate your help!!!
Re: Vlookup to return one value from multiple columns
Here is a sample of the spreadsheet. By the way, I failed to mention that there are 3 pivot tables on sheet 2. Table 1 (A:H), Table 2 (I:P) and Table 3 (Q:W).
Thank you so much for your response!
Re: IF formula to move values from one worksheet to another
Yes, it is what I came up with as well. Thanks you so much for your help!!!
Re: IF formula to move values from one worksheet to another
Thank you for viewing my post. I have resolved the problem.
I have two separate worksheets, and I am trying to create a Vlookup or Index and Match formula. Here is the example:
Sheet 1
Cell A1= Employee ID: 123-D.
Sheet2
Vlookup A1 from Sheet 1, and match the first five characters to Column A, Column I and Column P. If a match, return name (e.g. John Doe) in Sheet 1, cell B1.
Thanks so much for your help!!
Re: IF formula to move values from one worksheet to another
Please refer to tab 3 on the attachment. This is what I would like for the formula to produce on tab 2. This displays from tab 1 the individuals with 30 or above (Jan. column E; Feb. column I) unprocessed files and a 95% or greater rate (Jan. column F; Feb. column J). Thanks!
Re: IF formula to move values from one worksheet to another
No, both months need to reflect the unprocessed rate of 95% or above, which is located on tab one in column F for January and column J for February.
Also, there has to be 30 or more unprocessed files, which is located in column E for January and I (eye) for February on the first tab.
I really appreciate your help...
Thanks!
Re: IF formula to move values from one worksheet to another
I want the Unprocessed Rate 95% or greater to display in January and February on sheet 2, and the name of the individuals and their states to appear in columns A2 and B2 that meet this criteria. Sorry, I am new at creating Excel formulas.
Re: IF formula to move values from one worksheet to another
Sorry, can you please review this attachment!
Re: IF formula to move values from one worksheet to another
No, something like this in cells C2 and D2 on sheet 2. Also, I need to display the name and state for the individuals meeting that criteria. Thanks again!!!
Re: IF formula to move values from one worksheet to another
Thank you for your response! No, I need to show on sheet 2 only the Unprocessed rate for January and February of the individuals with a rate of 95% or greater with 30 or more files.
I need help to accomplish the following:
IF formula to transfer specific text and values from sheet 1 to sheet 2 (please refer to attachment). Sheet 2 should display the name, state and unprocessed rate for each month for individuals with a rate of 95% and 30 or more unprocessed files.
Any help would be greatly appreciated. Thank You!