EXCEL PROBLEM

Knowledge resource 1214 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
Featured 14 March 2026
Associate CA

N N V Satish&co

Hyderabad

CA

View Details
Company
Featured 28 March 2026
Accountant

Ashok Amol & Associates

New Delhi

B.Com

View Details
Company
Featured 13 April 2026
GST CONSULTANCY

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 28 March 2026
CA Final

Ashok Amol & Associates

New Delhi

CA Final

View Details
Company
Featured 19 March 2026
Article Assistant

Gupta Sachdeva & Co. Chartered Accountants

New Delhi

CA Final

View Details
Company
Featured 14 April 2026
GST CONSULTANT

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 12 March 2026
Customer Relationship Executive

TAXLET

Calicut

B.Com

View Details
Company
Featured 14 March 2026
Article Trainee

N N V Satish&co

Hyderabad

CA Inter

View Details