populate one worksheet from another
I have a reference number on one worksheet. I then want to search another
worksheet (Shet1) in the ssme workbook for that reference number. When found I want to copy all the info from the other columns (B, C) into similar columns on the new work sheet (Sheet2) Eg sheet 1 has the data and ColA is the ref number ColA ColB ColC 123 date amount Sheet2. I enter ColA data and want to then get data from Sheet1, Cols B C ColA 123 regards Chris |
Hi Chris
you can use the VLOOKUP function for this, in cell B1 of Sheet 2 type =VLOOKUP(A1,Sheet1!$A$1:$C$100,2,0) which says, lookup the value in A1, in the range A1:A100 on sheet 1 and return the associated value from the column adjacent to it where there is an exact match. for C1 of sheet 2 the formula will be =VLOOKUP(A1,Sheet1!$A$1:$C$100,3,0) Regards JulieD "Chris" wrote in message ... I have a reference number on one worksheet. I then want to search another worksheet (Shet1) in the ssme workbook for that reference number. When found I want to copy all the info from the other columns (B, C) into similar columns on the new work sheet (Sheet2) Eg sheet 1 has the data and ColA is the ref number ColA ColB ColC 123 date amount Sheet2. I enter ColA data and want to then get data from Sheet1, Cols B C ColA 123 regards Chris |
All times are GMT +1. The time now is 02:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com