Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
comparing two sheets og copy value
Hi
I have two sheets with about 500 rows "Sheet1": A1 3000 B1 3001 C1 3002 and furter on to about 500 "Sheet2": A1 3002 B1 3000 C1 3001 and furter on to about 500 The function I need has to be put in cell D1 in "sheet1" and need to check of any of the cells in column A in "sheet 2" has the value of A1 in "sheet1", if it does I need to put the value of F1 in "sheet2" into D1 in "sheet1" The cells in column A "sheet1" one has not the same rows as in "sheet2",, if they had the same row it would be easy :) Eks : A1 in "sheet1" have the value 3000, but in "sheet2" the value 3000 is in A7 Do anyone understand what I am looking for???? PLS help :) -- Just a regular user -- Just a regular user |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
comparing two sheets og copy value
sorry got posted 2 times, got a errormessage the first time, and tried again,
sorry -- Just a regular user Rockbear skrev: Hi I have two sheets with about 500 rows "Sheet1": A1 3000 B1 3001 C1 3002 and furter on to about 500 "Sheet2": A1 3002 B1 3000 C1 3001 and furter on to about 500 The function I need has to be put in cell D1 in "sheet1" and need to check of any of the cells in column A in "sheet 2" has the value of A1 in "sheet1", if it does I need to put the value of F1 in "sheet2" into D1 in "sheet1" The cells in column A "sheet1" one has not the same rows as in "sheet2",, if they had the same row it would be easy :) Eks : A1 in "sheet1" have the value 3000, but in "sheet2" the value 3000 is in A7 Do anyone understand what I am looking for???? PLS help :) -- Just a regular user -- Just a regular user |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
comparing two sheets og copy value
=IF(ISNA(VLOOKUP(A1,Sheet2!A:A,1,0),"",F1)
If the value is not found, D1 will stay blank. Copy down your column. "Rockbear" wrote: sorry got posted 2 times, got a errormessage the first time, and tried again, sorry -- Just a regular user Rockbear skrev: Hi I have two sheets with about 500 rows "Sheet1": A1 3000 B1 3001 C1 3002 and furter on to about 500 "Sheet2": A1 3002 B1 3000 C1 3001 and furter on to about 500 The function I need has to be put in cell D1 in "sheet1" and need to check of any of the cells in column A in "sheet 2" has the value of A1 in "sheet1", if it does I need to put the value of F1 in "sheet2" into D1 in "sheet1" The cells in column A "sheet1" one has not the same rows as in "sheet2",, if they had the same row it would be easy :) Eks : A1 in "sheet1" have the value 3000, but in "sheet2" the value 3000 is in A7 Do anyone understand what I am looking for???? PLS help :) -- Just a regular user -- Just a regular user |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
comparing two sheets og copy value
Did not work, sorry
=IF(ISNA(VLOOKUP(A4,'507.xls'!$A:$A,1,0),"",G4)) returned with #name? -- Just a regular user Sean Timmons skrev: =IF(ISNA(VLOOKUP(A1,Sheet2!A:A,1,0),"",F1) If the value is not found, D1 will stay blank. Copy down your column. "Rockbear" wrote: sorry got posted 2 times, got a errormessage the first time, and tried again, sorry -- Just a regular user Rockbear skrev: Hi I have two sheets with about 500 rows "Sheet1": A1 3000 B1 3001 C1 3002 and furter on to about 500 "Sheet2": A1 3002 B1 3000 C1 3001 and furter on to about 500 The function I need has to be put in cell D1 in "sheet1" and need to check of any of the cells in column A in "sheet 2" has the value of A1 in "sheet1", if it does I need to put the value of F1 in "sheet2" into D1 in "sheet1" The cells in column A "sheet1" one has not the same rows as in "sheet2",, if they had the same row it would be easy :) Eks : A1 in "sheet1" have the value 3000, but in "sheet2" the value 3000 is in A7 Do anyone understand what I am looking for???? PLS help :) -- Just a regular user -- Just a regular user |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
comparing two sheets og copy value
Oops, I missed a )
=IF(ISNA(VLOOKUP(A4,'507.xls'!$A:$A,1,0)),"",G4) "Rockbear" wrote: Did not work, sorry =IF(ISNA(VLOOKUP(A4,'507.xls'!$A:$A,1,0),"",G4)) returned with #name? -- Just a regular user Sean Timmons skrev: =IF(ISNA(VLOOKUP(A1,Sheet2!A:A,1,0),"",F1) If the value is not found, D1 will stay blank. Copy down your column. "Rockbear" wrote: sorry got posted 2 times, got a errormessage the first time, and tried again, sorry -- Just a regular user Rockbear skrev: Hi I have two sheets with about 500 rows "Sheet1": A1 3000 B1 3001 C1 3002 and furter on to about 500 "Sheet2": A1 3002 B1 3000 C1 3001 and furter on to about 500 The function I need has to be put in cell D1 in "sheet1" and need to check of any of the cells in column A in "sheet 2" has the value of A1 in "sheet1", if it does I need to put the value of F1 in "sheet2" into D1 in "sheet1" The cells in column A "sheet1" one has not the same rows as in "sheet2",, if they had the same row it would be easy :) Eks : A1 in "sheet1" have the value 3000, but in "sheet2" the value 3000 is in A7 Do anyone understand what I am looking for???? PLS help :) -- Just a regular user -- Just a regular user |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
comparing two sheets og copy value
I am still sorry it returns with #name?
and G4 is now H4, but it do not work -- Just a regular user "Sean Timmons" wrote: Oops, I missed a ) =IF(ISNA(VLOOKUP(A4,'507.xls'!$A:$A,1,0)),"",G4) "Rockbear" wrote: Did not work, sorry =IF(ISNA(VLOOKUP(A4,'507.xls'!$A:$A,1,0),"",G4)) returned with #name? -- Just a regular user Sean Timmons skrev: =IF(ISNA(VLOOKUP(A1,Sheet2!A:A,1,0),"",F1) If the value is not found, D1 will stay blank. Copy down your column. "Rockbear" wrote: sorry got posted 2 times, got a errormessage the first time, and tried again, sorry -- Just a regular user Rockbear skrev: Hi I have two sheets with about 500 rows "Sheet1": A1 3000 B1 3001 C1 3002 and furter on to about 500 "Sheet2": A1 3002 B1 3000 C1 3001 and furter on to about 500 The function I need has to be put in cell D1 in "sheet1" and need to check of any of the cells in column A in "sheet 2" has the value of A1 in "sheet1", if it does I need to put the value of F1 in "sheet2" into D1 in "sheet1" The cells in column A "sheet1" one has not the same rows as in "sheet2",, if they had the same row it would be easy :) Eks : A1 in "sheet1" have the value 3000, but in "sheet2" the value 3000 is in A7 Do anyone understand what I am looking for???? PLS help :) -- Just a regular user -- Just a regular user |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing Two Sheets | Excel Worksheet Functions | |||
Comparing 2 sheets | Excel Discussion (Misc queries) | |||
comparing 2 sheets | Excel Discussion (Misc queries) | |||
comparing 2 sheets | Excel Worksheet Functions | |||
in VBA Sheets("mysheet").Copy Befo=Sheets(1) how do i get a reference to the newly created copy of this sheet? | Excel Worksheet Functions |