Ask Your Question

"match" (in CALC Version: (x64)) is not working right... [closed]

asked 2019-07-26 19:17:57 +0200

Lew Merrick gravatar image

I am building a rather large and complex "design project management: (Calc) spreadsheet. The user selects a "Design Type" using a "validity" command. Elsewhere I use the "Match" command to get the "offset" from the validity's "source text." It does not always work. image description This is the "source for the "validity" and associated data. image description This is the "result" of my "match" and "offset" efforts.

The "Match" command is written as: "=MATCH(AMG6,$'Operational Data'.$AMC$3:$AMC$13)" in my code. ???

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by m.a.riosv
close date 2019-07-26 22:23:51.781216

1 Answer

Sort by » oldest newest most voted

answered 2019-07-26 22:14:18 +0200

Lew Merrick gravatar image

Yes -- I aman idiot! I left off the Exact Match 0 from my Match call. What mind???

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2019-07-26 19:17:57 +0200

Seen: 32 times

Last updated: Jul 26 '19