Go Back  DVD Talk Forum > General Discussions > Tech Talk
Reload this Page >

Simple EXCEL question

Tech Talk Discuss PC Hardware, Software, Internet and Other Technology

Simple EXCEL question

Old 01-15-04, 08:12 PM
  #1  
DVD Talk Gold Edition
Thread Starter
 
Join Date: Dec 1999
Location: Northern California
Posts: 2,161
Likes: 0
Received 0 Likes on 0 Posts
Simple EXCEL question

It seems like this should be relatively straightforward, but I can't figure it out.

I am trying to create a sheet which shows some organized data, using a bulk data sheet as the back bone. All I want to do is have a cell return a value that is in column C when column A is "X" and column B is "Y".

The data looks like this:

112 350 45654
112 450 98934
112 675 85842
115 350 99382
115 450 77432
115 675 83853

And I basically want to organize the data from column C on another worksheet on which I have made a form.

So C5 should be something like ="column C when A=112 and B=350"

How do I tell Excel that? I can do it with two columns with no problem using the LOOKUP function, but I can't get it to work with three. I've tried the IF function, sort of, but I'm not completely sure what the format should be on that.

Thanks for any help! I'm thinking this should be pretty easy but I'm not seeing the solution!
Old 01-15-04, 11:36 PM
  #2  
ngp
DVD Talk Gold Edition
 
Join Date: Oct 2000
Location: Twilight zone
Posts: 2,157
Likes: 0
Received 0 Likes on 0 Posts
Assuming that all the data is numeric and assuming that on Sheet1, you begin at cell A1, go to Sheet2 and input the following formula:

=IF(AND(Sheet1!A1=112,Sheet1!B1=350),Sheet1!C1,0)

On sheet two, using the formula in cell A1, this formula returns the value of 45654. Is this what you're looking for?

If you were to copy this forumla down, it would change the cell references relative to the cell being populated. For example, copying this into Sheet2's cell A2, you would get the following formula:

=IF(AND(Sheet1!A2=112,Sheet1!B2=350),Sheet1!C2,0)
Old 01-16-04, 05:07 AM
  #3  
DVD Talk Gold Edition
Thread Starter
 
Join Date: Dec 1999
Location: Northern California
Posts: 2,161
Likes: 0
Received 0 Likes on 0 Posts
That is on the right track. I need it to search through the long list of A1 through A9000 and B1 through B9000 for the one case where A and B equal my specific criteria in the same row. Then I want C to be displayed.

Your logic formula will work, I just don't know how to make it search through all values of A and B for my match.

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Thread Tools
Search this Thread

Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service - Do Not Sell My Personal Information

Copyright 2018 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.