I'm having trouble making an INDEX MATCH function that can look for either phrase in the MATCH value for column headings, not both, either or. This is the formula.
=IF(A10=0,"",INDEX('PMI Gun Data "Paste Here"'!$A$1:$BZ$1000,MATCH(A10,'PMI Gun Data "Paste Here"'!$A:$A,0),MATCH("Alloy1",'PMI Gun Data "Paste Here"'!$1:$1,0)))
I want to add "Match #1" to "Alloy1" in the second MATCH function and have it search for one or the other.
Tvboy676
- Welcome to the forum.
- Regional differences matter. Please edit your profile to show a meaningful location. Canada, USA, UK ... etc suffices
- Please attach an Excel workbook representative of what you have and desired output ... including layout(s).
Of note: The 'paperclip' icon has not worked for some time. So please save yourself some grief.
To attach a file to your post: (Please no pics or screenshots ... saves retyping data.),
be sure to desensitize the data
The file name will appear at the bottom of your reply.
- click “Go Advanced” (next to Post Quick Reply – bottom right),
- scroll down until you see “Manage Attachments”, click that,
- click “Browse”.
- select your file(s)
- click “Upload”
- click “Close window”
- click “Submit Reply”
Dave
Added copy of file being worked with.
Last edited by Tvboy676; 09-13-2019 at 08:32 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks