Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-03-2012, 04:16 PM
Becki Becki is offline Using IF and VLOOKUP together Windows 7 64bit Using IF and VLOOKUP together Office 2007
Novice
Using IF and VLOOKUP together
 
Join Date: Apr 2012
Posts: 1
Becki is on a distinguished road
Default Using IF and VLOOKUP together

I have two sheets in one workbook. I want to write a formula that will import the data from column C of Sheet 1 onto column C of Sheet 2 IF cell A1 AND A2 in sheet 1 match cells A1 AND A2 in sheet 2.



Can you please help me?
Reply With Quote
  #2  
Old 04-05-2012, 10:30 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Using IF and VLOOKUP together Windows 7 32bit Using IF and VLOOKUP together Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Welcome to the forum.

Please can you attach an example workbook which demonstrates what you need?
Reply With Quote
  #3  
Old 04-06-2012, 05:32 PM
caholmes caholmes is offline Using IF and VLOOKUP together Windows Vista Using IF and VLOOKUP together 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
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using IF and VLOOKUP together Vlookup ibrahimaa Excel 5 03-04-2012 11:24 AM
Vlookup ibrahimaa Excel 8 01-03-2012 09:32 PM
Vlookup Karen615 Excel 4 09-12-2011 02:30 PM
Using IF & VLOOKUP together junction Excel 7 11-18-2010 05:15 AM
Help with VLOOKUP sakhtar Excel 2 07-24-2010 07:39 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:49 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft