K Kg Teh New Member Oct 22, 2013 #1 Hi all, It would be appreciated if anyone here willing to solve my lookup problem. Currently I need to lookup a value from a Data Table and return the value to the report format. Kindly refer to the attach file for reference. Thank you !! Attachments Question.xlsx Question.xlsx 10.1 KB · Views: 20
Hi all, It would be appreciated if anyone here willing to solve my lookup problem. Currently I need to lookup a value from a Data Table and return the value to the report format. Kindly refer to the attach file for reference. Thank you !!
Luke M Excel Ninja Staff member Oct 22, 2013 #2 In cell D17, confirm this formula as an array using Ctrl+Shift+Enter =INDEX($C$5:$E$10,MATCH(A17&C17,$A$5:$A$10&$B$5:$B$10,0),MATCH(B17,$C$4:$E$4,0)) Drag down to the other cells as needed.
In cell D17, confirm this formula as an array using Ctrl+Shift+Enter =INDEX($C$5:$E$10,MATCH(A17&C17,$A$5:$A$10&$B$5:$B$10,0),MATCH(B17,$C$4:$E$4,0)) Drag down to the other cells as needed.
