Excel 2007 : Function to enter data in 2 columns and get data in 3rd Column automatically

Hi Somali,

use the below function :-

{=INDEX($A$2:$C$12,MATCH(A18&B18,$A$2:$A$12&$B$2:$B$12,0),3)}

See the attachment :-
Datasheet.xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>