From India, Madras



From India, Nasik
From India, Gurgaon
Glad for your attitide to help in excel forumas. I have a problem where i have to segretate som information on the basis of its contents.
Air - 1
Train -2
Bus - 3
I have cells containing various words from which i have to search above three words in their respective column and write its corresponding value in same row. I have tried FIND and SEARCH Functions, but not succeded. Give me information at my mail ID "vijay_adwade@rediffmail.com".
Regards
Viju
From India, Pune
From India, New Delhi
From Pakistan, Karachi
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 as everyone can benefit.
Thanks and regards
Nipun
I want to trunc a word for example :
excel coulm.
------------------------------------------------
A | | B | C | D | E | F | G | H |
R ------------------------------------------------|
O 1 | JAGJEET | J | A | G | J | E| E | T|
W -----------------------------------------------|
S 2 | | | | | | | | | |
IN xls can i did it
Please help me
If it is possible in excle please tell me how
please send detail regarding this on my id
with regards
jagjeet singh
From India, Bhatinda
Insert the Match formula in the third argument of the VLookup formula.
Step 1: Define 2 names, see screen shot
Select Row 1, press Ctrl+F3, type the name Row1 in the Names in workbook field, and click OK.
Select the data table by pressing Ctrl+*. Then press Ctrl+F3, enter Data in the Names in workbook field, and click OK.
Open an adjacent worksheet, and select cell A1.
In cell A1 type 4/1/2001.
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.)
Results of calculation: 7.
Enter the account number 201 into cell A2.
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.
Calculation results: 7,981.
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.- Press Ctrl+V and press Enter.
The final result is a nested formula is
=VLOOKUP (A2, Data, MATCH(A1, Row 1, 0))
Screenshot // Combine the VLookup and Match formulas in Microsoft Excel
JA
From India, Madras