Hi,
I have a problem with my excel encoding,
Here's some points that I want to do in excel.
I have a worksheet containing a 1st Quarter Sheet, and Database Sheet
On 1st_QSheet at Column C, I want to inter either an ITEM# (Column A) or DISCPIRTION (Column B) found on Database Sheet.
Which automatically show the contents of Column C,D,E in Database Sheet at 1st_QSheet Column D,E,F.
Here's the formula I came up with,
Show index match at Column A
=INDEX(Database!$A$3:$D$10317,MATCH($C5,Database!$A$3:$A$10317,0),MATCH(E$2,Database!$A$1:$D$1,0))
Show index match at Column B
=INDEX(Database!$A$3:$D$10317,MATCH($C5,Database!$B$3:$B$10317,0),MATCH(E$2,Database!$A$1:$D$1,0))
Is there any other ways to combine the two match function?
MATCH($C5,Database!$A$3:$A$10317,0)
MATCH($C5,Database!$B$3:$B$10317,0)
I can't combined the two MATCH function because it says of too many arguments,
=INDEX(Database!$A$3:$D$10317,MATCH($C5,Database!$B$3:$B$10317,$C5,Database!$A$3:$A$10317,0),MATCH(E$2,Database!$A$1:$D$1,0))
This will be allowing me to input either the ITEM# or DISCRIPTION and still be able to show the same result.
My purpose is to encode either of the two lookup array the ITEM# and DISCRIPTION column at the Database Sheet.
I have attached a file for your reference and hoping for a possible result.
DAILY DETAILED REPORT_POS_2.xlsx
Thank you & God Bless.