Forums
New posts
Articles
Product Reviews
Policies
FAQ
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Menu
Log in
Register
Install the app
Install
Forums
Apple Computing Products:
macOS - Apps and Programs
Table look up help
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="Rip Vega" data-source="post: 1671136" data-attributes="member: 72652"><p>I have a table, 12 columns x 18 rows, and I can't figure out how to return a value from a single cell.</p><p></p><p>If I look up a value from the top row and another value from the left most column, I need to return the value in the intersecting cell.</p><p></p><p>Here's an image that hopefully explains it better:</p><p></p><p><img src="https://www.evernote.com/l/AAGgYus1jZxGpq-GYQuGlWdz8lLEvdXXPn8B/image.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p></p><p>I'm sure I managed this many years ago in Exel but just can't figure it in Numbers. (and probably couldn't in Exel now, if I'm honest<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite8" alt=":D" title="Big grin :D" loading="lazy" data-shortname=":D" />)</p><p></p><p>Any help would be appreciated.</p></blockquote><p></p>
[QUOTE="Rip Vega, post: 1671136, member: 72652"] I have a table, 12 columns x 18 rows, and I can't figure out how to return a value from a single cell. If I look up a value from the top row and another value from the left most column, I need to return the value in the intersecting cell. Here's an image that hopefully explains it better: [IMG]https://www.evernote.com/l/AAGgYus1jZxGpq-GYQuGlWdz8lLEvdXXPn8B/image.png[/IMG] I'm sure I managed this many years ago in Exel but just can't figure it in Numbers. (and probably couldn't in Exel now, if I'm honest:D) Any help would be appreciated. [/QUOTE]
Verification
Post reply
Forums
Apple Computing Products:
macOS - Apps and Programs
Table look up help
Top