LinkBack URL
About LinkBacks
hi I am trying to match a sequence no from report sheet to a data entry sheet using index and match in a single formula but there are three criteria columns
Tariif ,Description and origin as criteria
Can anyone help
macro for index and match multiple columns in a single formula
hi I am trying to match a sequence no from report sheet to a data entry sheet using index and match in a single formula but there are three criteria columns
Tariif ,Description and origin as criteria
Can anyone help
It appears to me that you are wanting to find the Sequence No that belongs to the entries on the Data Entry worksheet and have that value in column H.
Array enter in 'Data Entry'!H2 and fill down:
Formula:
=INDEX('Report Summary '!$F$2:$F$61,MATCH('Data Entry'!A2&B2&C2,'Report Summary '!$D$2:$D$61&'Report Summary '!$B$2:$B$61&'Report Summary '!$C$2:$C$61,0))
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Duplicate:- please delete
Last edited by newdoverman; 02-13-2016 at 03:31 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks