Reg. Excel Formula

Please tell me which formula could be used to get the text value from another sheet if other text is similar with a criteria or range.

Suppose I have a sheet containing some name anf group name. now i pasted name in another sheet  and want to insert a formula in that sheet in such a way so that gropu name matching with the name will display itself. I tried to use if(lookup) formula, but its not working.

Guide me its urgent.

Replies (1)

The command is vlookup. After u hv  selected  the range press f4 key... try again... any problem..thn will surely gv u a step by step procedure.

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
12 November 2026
Auditor

Oz Taxation

Vijayawada

Graduate (Any)

View Details
Company
Featured 17 November 2026
Chartered Accountant

M/s. A V C & Co.

New Delhi

CA

View Details
Company
Featured ARTICLESHIP 18 November 2026
Articles

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Foundation

View Details
Company
28 October 2026
Assistant Director/ Associate Director-Finance & Accounting

Krea University

Chennai

CA

View Details
Company
19 November 2026
Accounts & Taxation Executive

MCSR and Associates LLP

Hyderabad

CA Inter

View Details
Company
ARTICLESHIP 25 October 2026
Article Intern (CA Articleship)

Arpan Bohra & Co

Hyderabad

CA Inter

View Details
Company
ARTICLESHIP 07 November 2026
Article Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
13 November 2026
Accountant

New Mobile India

Muzaffarpur

B.Com

View Details