#1
|
|||
|
|||
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? |
#2
|
||||
|
||||
Welcome to the forum.
Please can you attach an example workbook which demonstrates what you need? |
#3
|
|||
|
|||
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 "" |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |