View Single Post
 
Old 04-06-2012, 05:32 PM
caholmes caholmes is offline Windows Vista Office 2007
Advanced Beginner
 
Join Date: Dec 2008
Location: Sydney, Australia
Posts: 54
caholmes is on a distinguished road
Default

Hi Becki,

firstly, a formula will never import data from one location to another however it can link to existing data or perform a calculated result. Without a spreadsheet to reference you would need to use a formula that looks something like this in column C of sheet 2.

=IF(AND(Sheet1!A1=A1,Sheet1!B1=B1),Sheet1!C1,"")

Anything that doesn't match will display a blank or ""
Reply With Quote