Excel Querry - Reply Needed

Dear Sir(s),

I am having doubt, kindly clarify;

1) "A" cell having some text data, basing on that with formula automatically get the wanted result in "B" column

say for example;

A is having Hyderabad

In B  cell formula should get result like, if A is having Hyderabad, update with "ABC Limited" other wise "XYZ limited".

2) if A cell having Alpha numeric data ABCDE1253MXM007, I have to put formula from right to 4th letter is "M" or "D" result to be updated.

Kindly give suitable formula.

Thanks in Advance.

Replies (2)

use the formula in B1 Cell =+IF(MID(A1,12,1)="M","Manufacturer","Dealer")

Many Many Thanks for ur reply, it is functioning , kindly give if only text is there in before cell,

i.e., 1) question.

Thanks in advance

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured ARTICLESHIP 28 October 2026
CA- Inter and Articles

N N V Satish & Co.,

Hyderabad

CA Inter

View Details
Company
31 October 2026
Accountants

sankaran and krishnan

New Delhi

B.Com

View Details
Company
Featured 07 November 2026
Chartered Accountant

DPV & Associates

Chennai

CA

View Details
Company
20 November 2026
Senior Accountant

Compass Tex India Pvt Ltd

Coimbatore

CA Inter

View Details
Company
10 November 2026
Direct Tax Manager

CAAQ CONSULTANCY PVT LTD

New Delhi

CA Final

View Details
Company
13 November 2026
Accountant

New Mobile India

Muzaffarpur

B.Com

View Details
Company
ARTICLESHIP 07 November 2026
Article Assisstant

DPV & Associates

Chennai

CA Inter

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

Arpan Bohra & Co

Hyderabad

CA Inter

View Details