Trying to look up a value on one spreadsheet from another

[Jammin_JP]

Hello, This is my first post and I hope I can articulate my question well. Basically I have a spreadsheet I have to reconcile every 2 weeks. in one column on my target spreadsheet I have city stations such as:
ABE
ACV
ORD
I need information from another spreadsheet that has a column with city stations just like the other spreadsheet, but there are six (6) other column headings I would need to look into to see if there is a value above 0. My goal is to look up by station (there are over 200), and see if the row of that station contains any values above zero. so I guess a conditional, but I want to search the whole column of stations and all of the rows. the other sheet is like this:
AX S5 YV
ABE 0 0 0
ACV 25 0 0
ADE 0 4 0
so in my target sheet, I want to know if ALL of the columns have a zero amount, or if one column has an above zero amount (like ACV). In that case, the column I am entering my formula in would say "true", there is an above zero amount for ACV, but FALSE, all zeros for ABE. Thank you!
Joe

 

[liveinhope]

2 QUESTIONS

- would those 6 columns ever have values less than zero ?
- can you add another column llike my "total" column that sums the values in B-G for that row

[TABLE="width: 305"]
<TBODY>[TR]
[TD]AX</SPAN>[/TD]
[TD]col1</SPAN>[/TD]
[TD]col2</SPAN>[/TD]
[TD]col3</SPAN>[/TD]
[TD]col4</SPAN>[/TD]
[TD]col5</SPAN>[/TD]
[TD]col6</SPAN>[/TD]
[TD]total</SPAN>[/TD]
[/TR]
[TR]
[TD]ABE</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0</SPAN>[/TD]
[/TR]
[TR]
[TD]ACV</SPAN>[/TD]
[TD="align: right"]25</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]25</SPAN>[/TD]
[/TR]
[TR]
[TD]ADE</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]4</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]4</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL><COL span=6><COL></COLGROUP>[/TABLE]

 

[Jammin_JP]

Thank you liveinhope for your quick response. There are never below zero values. and the totaling column does not come into play. My fault, I need to be more specific. I am actually comparing 2 columns. I will have to rethink how to phrase my question.

 

[Jammin_JP]

Hello. In the target sheet.. it looks as follows. There may be many records of one station (ABE). The next column is which retailer supposedly delivers there.

[TABLE="width: 128"]
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]STN[/TD]
[TD="width: 64"]DELIVERY[/TD]
[/TR]
[TR]
[TD="class: xl64"]ABE[/TD]
[TD="class: xl65"]CO[/TD]
[/TR]
[TR]
[TD="class: xl64"]ABE[/TD]
[TD="class: xl65"]UA[/TD]
[/TR]
[TR]
[TD="class: xl64"]ABE[/TD]
[TD="class: xl65"]AX[/TD]
[/TR]
[TR]
[TD="class: xl64"]ABE[/TD]
[TD="class: xl65"]UA[/TD]
[/TR]
</tbody>[/TABLE]

the other sheet is as follows:

Stn AX S5 G7 YV OO EV
ABE - - - - - 21
ABQ - 7 - - 110 143

you can see that AX does not in fact deliver to ABE. So I would like to know if there is some code I can use to search through each delivery company, to see if they do in fact deliver to ABE, or ABQ, or other stations.

Thank you!
Joe