Forum

Notifications
Clear all

Code Corresponding List

3 Posts
2 Users
0 Reactions
67 Views
(@meyanui)
Posts: 24
Eminent Member
Topic starter
 

Regards,

I need assisatnce for:

A formula for D3 where {if cell E3 is Examination, let the code automatically be 38}

Thanks for assistance in advance

 
Posted : 27/04/2018 6:50 am
(@sunnykow)
Posts: 1417
Noble Member
 

In cell D3 enter 

=INDEX(A:A,MATCH(E3,B:B,0))

Sunny

 
Posted : 27/04/2018 10:31 am
(@meyanui)
Posts: 24
Eminent Member
Topic starter
 

SunnyKow said
In cell D3 enter 

=INDEX(A:A,MATCH(E3,B:B,0))

Sunny  

Thank you very much Sunny. It's perfect

 
Posted : 27/04/2018 3:36 pm
Share: