Complex If Then formulas
Heres what i am trying to do. I have a master list in one worksheet
displaying all program numbers available 1-500 and what stations they are installed in (1-10). In another worksheet i have a database query displaying all programs used. But the query does not contain the work station. I want to combine them where my final worksheet displays 2 columns: programs used / station. I have tried to fiddle with If then statements but have had no success. The problem is that the cells don't match up. Program number 50 might be in cell 60 one day and move to cell 65 the next depending on the programs now being used or not being used. The master list however is locked. program 1 is always in the same cell. Is there someway to set it up so that: A B C D 1 Program used Station All programs Station 2 100 If A2= C2:C502 then D corresponding 1-500 3 110 x 4 230 x It might only be possible using visual basic. If thats the case I have little experience with that. I could just input the stations by hand but i am lazy and want my computer to do it for me. Any suggestions would be appreciated. |
Use the VLOOKUP() function
=VLOOKUP(A2, C2:D02,2,false) "Sneed924" wrote: Heres what i am trying to do. I have a master list in one worksheet displaying all program numbers available 1-500 and what stations they are installed in (1-10). In another worksheet i have a database query displaying all programs used. But the query does not contain the work station. I want to combine them where my final worksheet displays 2 columns: programs used / station. I have tried to fiddle with If then statements but have had no success. The problem is that the cells don't match up. Program number 50 might be in cell 60 one day and move to cell 65 the next depending on the programs now being used or not being used. The master list however is locked. program 1 is always in the same cell. Is there someway to set it up so that: A B C D 1 Program used Station All programs Station 2 100 If A2= C2:C502 then D corresponding 1-500 3 110 x 4 230 x It might only be possible using visual basic. If thats the case I have little experience with that. I could just input the stations by hand but i am lazy and want my computer to do it for me. Any suggestions would be appreciated. |
All times are GMT +1. The time now is 07:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com