i'm trying to match 2 columns from 2 tables,and then in table 1 return the value from table 2,function i use in output(orange color column) column is =IF(A:D,E,""),but not working,any ideas why?
Capture1.PNG
i'm trying to match 2 columns from 2 tables,and then in table 1 return the value from table 2,function i use in output(orange color column) column is =IF(A:D,E,""),but not working,any ideas why?
Capture1.PNG
Consider your table ranges as above, put at B2 and copied down as necessary
=IFERROR(INDEX($E$2:$E$4,MATCH(A2,$D$2:$D$4,0)),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks