How to find a data in Sheet1,automatic transfer to Sheet2(Excel)

G

Guest

Pls in a specified box of Sheet 2, I want to capture a data in Sheet 1. This
data need to fulfill two condition. For example, if the name is equal to
"Paul" and the age is equal to 30, then this box of data will be captured by
a specified box of Sheet 2. .Pls help to solve and advise the formula.

Thx a lot in advance.

Edmond
 
T

Tim

If I understand correctly, you want a formula such as this


=IF(AND(Sheet1!A1="Paul",Sheet1!A2=30),Sheet1!A3)

Where "A1" is the cell containing the name, "A2" is the cell containing the
age and "A3" is the cell containing the speicified data you want to capture.

Hope this helps

Tim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

jump to cell in sheet2 when values in sheet1 is true 3
Automatic populate Sheet2 with data from Sheet1 based on criteria. 2
Sheet1 Data Autometically Uploaded in Sheet2 2
move blank data 10
mail merge from Excel Data 1
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Data of Sheet1 should gets autometically posted in Sheet2 2
auto transfer data in sheet2 (selected data) 1

Top