Lookup with Index / Match

[franciz]

Hi all

I have a workbook contains 4 worksheets with the following data

Col A Col B Col C Col D
ac name type details
0001 abc USD abc123
0001 abc EUR abc456
0001 abc GBP abc789
0002 xyz EUR xyz123
0002 xyz USD xyz456
0003 jkl GBP jkl123
0003 jkl USD jkl321

I want to look up the value in :
1) name when given ac or vice versa in txtbox1,if not found a msgbox will
show as
" no match found". For example, given ac 0001 and the name abc will appear
2) detail after finding the name in 1) and given the type, for example
abc456 will
appear in txtbox2 after found abc form the above and input EUR, if not
msgbox show " no such type"

Would appreciate to know how does the functions works in codes.

Thanks in advance.