Using IF and VLOOKUP together

		Microsoft Office Forums > Microsoft Excel > Excel
Using IF and VLOOKUP together

FAQ

Thread Tools

Display Modes

04-06-2012, 05:32 PM

caholmes

Windows Vista Using IF and VLOOKUP together

Office 2007

Advanced Beginner

Join Date: Dec 2008

Location: Sydney, Australia

Posts: 54

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 ""

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:50 AM.