EXCEL PROBLEM

 IF ANY ONE KNOW ABOUT "V-LOOKUP" & "H-LOOKUP"

Please TELL ME IN DETAILS.

Replies (3)
For Using V lookup u have 2 use 2 sheets, one is base sheet and the other where u want all the details regarding any particular column. like u have E Ids and name in 1st sheet, let's say 15 names and Ids,and u want 2 choose names from the 1st sheet randomly in the 2nd sheet on the basis of E Ids. u use the formula in the 2nd sheet =vlookup(select the ID column in the 2nd sheet,move on to the 1st sheet and select E Id and name column,no. of columns in 1st sheet{here2},0). if u have any problem regarding this pls ask me on the harbinder_85 @ yahoo.co.in, i'll attach the sheet for the understanding. one more thing Vlookup is vertical lookup and Hlookuup is horizontal.
Ritesh you can take help of microsoft office....you will find it in excel itself....i am sayin that coz it will help you better as it gives illustration also...try that, if it doesn't help we'll look for something else....ok.
Mail ur mail add. to get Excel n tally shortcuts at
cajitendergarg @ gmail.com

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
08 October 2026
Accounts and Tax Associate

POOJA R TELI & CO

Pune

CA Inter

View Details
Company
19 October 2026
Accountant

Jari Saree Center

New Delhi

Others

View Details
Company
ARTICLESHIP 07 October 2026
Article Trainee/ CMA Trainee

RMA And Associates LLP

New Delhi

CA Inter

View Details
Company
14 October 2026
Asst. Manager/Dy Manager (Costing)

manufacturing

Pune

CMA

View Details
Company
06 October 2026
Assistant Manager - Audit and Compliance

Ravi K Jain & Co

Noida

Others

View Details
Company
Featured ARTICLESHIP 06 October 2026
Semi Qualified

AJAY SINGH AND CO LLP

Thane

CA Final

View Details
Company
30 September 2026
Senior Accounts Executive

Codeboard Technology

Chennai

MBA

View Details
Company
10 October 2026
Accounts Associate Level 1

Abic and Mani Chartered Accountants

Kottayam

B.Com

View Details