EXCEL PROBLEM

Knowledge Sharing 1235 views 3 replies

 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


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
01 June 2026
Audit, Taxation & Compliance Executive

R P S K & Associates

Nashik

CA Inter

View Details
Company
Featured 15 June 2026
Senior Auditor

N. Dhawan & Co

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 27 May 2026
CA Article Trainee

Rahul Dang & Associates-Chartered Accountants

Pune

CA Inter

View Details
Company
ARTICLESHIP 31 May 2026
Article Assistant

KPRS And Associates

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 09 June 2026
Article Trainee

Numbertree LLP

Mumbai

CA Inter

View Details
Company
29 May 2026
Accounts assistant

Shubh Consultancy

Mumbai

Graduate (Any)

View Details
Company
29 May 2026
Company Secretary - Part time

Shaswat initial support private limited

Ahmedabad

CS

View Details
Company
ARTICLESHIP 04 June 2026
Article

Rakhecha & Co.

New Delhi

CA Inter

View Details