Forum

Notifications
Clear all

Lookup value from a range

3 Posts
2 Users
0 Reactions
141 Views
(@nds)
Posts: 2
New Member
Topic starter
 

Dear sir(s), this is my real job problem. Sir, please solve this.

When I type any character from the following table ranges, then Header (Name of official) should be populated.

N.B. : Vlookup / IF formulas I know very well. Plz solve by other formulas.

Plz c file in attachment.

 

Nitin Shukla

 
Posted : 03/10/2020 4:35 am
(@questvba)
Posts: 125
Estimable Member
 

Hi Nitin Shukla,
Here is a solution

 

BR,

Lionel

 
Posted : 03/10/2020 8:17 am
(@nds)
Posts: 2
New Member
Topic starter
 

Hi, Lionel Baijot,

What a nice solution.  It's working. 

I highly appreciate your prompt & precise response.

Very nice of U. Thanx.

Nitin Shukla

 
Posted : 04/10/2020 10:48 am
Share: