Dear Guys, I am ready to serve you. Have You Any Doubt In Excel Formulas? Post your suggestion . Regards, JA
From India, Madras
Acknowledge(0)
Amend(0)
67From India, Madras
Acknowledge(0)Amend(0)
yes i am facing so many problem in exel so please give me a Detail information about exel please. Regard Kamlesh
From India, Nasik
Acknowledge(0)Amend(0)
From India, Nasik
Acknowledge(0)Amend(0)
Hi Would request you to kindly upload the same on Cite HR as all members would be able view the same.
From India, Gurgaon
Acknowledge(0)Amend(0)
From India, Gurgaon
Acknowledge(0)Amend(0)
Hi JA,
I'm glad for your attitude to help in Excel forums. I have a problem where I have to segregate some information based on its contents.
Air - 1 Train - 2 Bus - 3
I have cells containing various words from which I have to search the above three words in their respective columns and write their corresponding values in the same row. I have tried using the FIND and SEARCH functions, but have not succeeded. Please provide me with information at my email address "vijay_adwade@rediffmail.com".
Regards, Viju
From India, Pune
Acknowledge(0)Amend(0)
I'm glad for your attitude to help in Excel forums. I have a problem where I have to segregate some information based on its contents.
Air - 1 Train - 2 Bus - 3
I have cells containing various words from which I have to search the above three words in their respective columns and write their corresponding values in the same row. I have tried using the FIND and SEARCH functions, but have not succeeded. Please provide me with information at my email address "vijay_adwade@rediffmail.com".
Regards, Viju
From India, Pune
Acknowledge(0)Amend(0)
How can we calculate the time spent by an employee, in case the company gives double payment for overtime? The working hours are "8 hours" per day, and more than 8 hours means overtime hours. How could we calculate on a monthly basis, supposing an employee takes some leaves as well in Excel? Try to extend your supposition to address every doubt for calculating overtime hours for an employee in Excel. Thank you.
From India, New Delhi
Acknowledge(0)Amend(0)
From India, New Delhi
Acknowledge(0)Amend(0)
Hi, I just need a salary reconciliation format which must show the last month salary defference and tax format. Regards, M.Jasim Balich
From Pakistan, Karachi
Acknowledge(0)Amend(0)
From Pakistan, Karachi
Acknowledge(0)Amend(0)
Hi JA,
This is a good initiative, and Excel must be the second most commonly used (if not the most) MS Office application by HR and many other professionals. Thus, I would second Jaipreet's request to kindly upload the same on Cite HR so everyone can benefit.
Thanks and regards,
Nipun
Acknowledge(0)Amend(0)
This is a good initiative, and Excel must be the second most commonly used (if not the most) MS Office application by HR and many other professionals. Thus, I would second Jaipreet's request to kindly upload the same on Cite HR so everyone can benefit.
Thanks and regards,
Nipun
Acknowledge(0)Amend(0)
Dear Sir,
I want to truncate a word, for example: "excel column."
------------------------------------------------
| A | | B | C | D | E | F | G | H |
------------------------------------------------
| 1 | JAGJEET | J | A | G | J | E | E | T |
------------------------------------------------
| 2 | | | | | | | | |
------------------------------------------------
In Excel, can I do it? Please help me. If it is possible in Excel, please tell me how. Please send details regarding this to my email address: Jagjeet_1983@rediffmail.com.
With regards,
Jagjeet Singh
From India, Bhatinda
Acknowledge(0)Amend(0)
I want to truncate a word, for example: "excel column."
------------------------------------------------
| A | | B | C | D | E | F | G | H |
------------------------------------------------
| 1 | JAGJEET | J | A | G | J | E | E | T |
------------------------------------------------
| 2 | | | | | | | | |
------------------------------------------------
In Excel, can I do it? Please help me. If it is possible in Excel, please tell me how. Please send details regarding this to my email address: Jagjeet_1983@rediffmail.com.
With regards,
Jagjeet Singh
From India, Bhatinda
Acknowledge(0)Amend(0)
Solution
Insert the Match formula in the third argument of the VLookup formula.
Step 1: Define 2 names
1. Select Row 1, press Ctrl+F3, type the name Row1 in the Names in workbook field, and click OK.
2. Select the data table by pressing Ctrl+*. Then press Ctrl+F3, enter Data in the Names in workbook field, and click OK.
Step 2: Enter the Match formula
1. Open an adjacent worksheet, and select cell A1.
2. In cell A1, type 4/1/2001.
3. In cell B1, enter the formula =MATCH(A1, Row1, 0). (Be careful to enter the value 0 in the third argument to specify the search for an exact value.)
4. Results of calculation: 7.
Step 3: Enter the Vlookup formula
1. Enter the account number 201 into cell A2.
2. Enter the formula =VLOOKUP(A2, Data, B1) in cell B2. In the third argument of the VLookup formula, select a cell which contains the Match formula.
3. Calculation results: 7,981.
Step 4: Combine the formulas
1. In the formula bar (Match formula) of cell B1, select the formula without the = sign, press Ctrl+C, and click the Cancel sign (from the left of the formula in the formula bar). Select cell B2, and in the formula bar, select the address B1.
2. Press Ctrl+V and press Enter.
3. The final result is a nested formula:
=VLOOKUP(A2, Data, MATCH(A1, Row 1, 0))
Screenshot // Combine the VLookup and Match formulas in Microsoft Excel
Regards,
JA
From India, Madras
Acknowledge(0)Amend(0)
Insert the Match formula in the third argument of the VLookup formula.
Step 1: Define 2 names
1. Select Row 1, press Ctrl+F3, type the name Row1 in the Names in workbook field, and click OK.
2. Select the data table by pressing Ctrl+*. Then press Ctrl+F3, enter Data in the Names in workbook field, and click OK.
Step 2: Enter the Match formula
1. Open an adjacent worksheet, and select cell A1.
2. In cell A1, type 4/1/2001.
3. In cell B1, enter the formula =MATCH(A1, Row1, 0). (Be careful to enter the value 0 in the third argument to specify the search for an exact value.)
4. Results of calculation: 7.
Step 3: Enter the Vlookup formula
1. Enter the account number 201 into cell A2.
2. Enter the formula =VLOOKUP(A2, Data, B1) in cell B2. In the third argument of the VLookup formula, select a cell which contains the Match formula.
3. Calculation results: 7,981.
Step 4: Combine the formulas
1. In the formula bar (Match formula) of cell B1, select the formula without the = sign, press Ctrl+C, and click the Cancel sign (from the left of the formula in the formula bar). Select cell B2, and in the formula bar, select the address B1.
2. Press Ctrl+V and press Enter.
3. The final result is a nested formula:
=VLOOKUP(A2, Data, MATCH(A1, Row 1, 0))
Screenshot // Combine the VLookup and Match formulas in Microsoft Excel
Regards,
JA
From India, Madras
Acknowledge(0)Amend(0)
Your company doesn't sound very enjoyable. Can you elaborate on your request? Are you merely asking for a timer to tell you how long Excel has been opened? What if the user reboots the PC, what do you want then? What if the user goes on a break but leaves Excel open?
---
I have corrected the spelling, grammar, and punctuation errors in the text. The paragraphs have been properly formatted with a single line break between them. The original meaning and tone of the message have been preserved.
From India, Madras
Acknowledge(0)Amend(0)
---
I have corrected the spelling, grammar, and punctuation errors in the text. The paragraphs have been properly formatted with a single line break between them. The original meaning and tone of the message have been preserved.
From India, Madras
Acknowledge(0)Amend(0)
Your company doesn't sound very enjoyable.
Can you elaborate on your ask... Are you merely asking for a timer to tell you how long Excel has been opened? What if the user reboots the PC? What do you want then? What if the user goes on a break but leaves Excel open?...
From India, Madras
Acknowledge(0)Amend(0)
Can you elaborate on your ask... Are you merely asking for a timer to tell you how long Excel has been opened? What if the user reboots the PC? What do you want then? What if the user goes on a break but leaves Excel open?...
From India, Madras
Acknowledge(0)Amend(0)
Dear all I hope this post will be help full... Regards Ramakrishna
From India, Hyderabad
Acknowledge(0)Amend(0)
From India, Hyderabad
Acknowledge(0)Amend(0)Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
Vlookup in Excel.xls
Excel Formulas.ppt