Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lookup with Index / Match
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup H&V...or match...index??? | Excel Discussion (Misc queries) | |||
Lookup, index, match? | Excel Worksheet Functions | |||
Lookup or Index or Match, not sure. | Excel Programming | |||
index?lookup?match?if? | New Users to Excel | |||
MATCH, INDEX, LOOKUP - Help! | Excel Worksheet Functions |