Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-30-2009, 03:40 AM
thelauncher thelauncher is offline Using Vlookup & IF together Windows Vista Using Vlookup & IF together Office 2003
Novice
Using Vlookup & IF together
 
Join Date: Nov 2009
Posts: 1
thelauncher is on a distinguished road
Question Using Vlookup & IF together

Hi all,



I'm having trouble trying to figure out a formula using IF and Vlookup. Basically what I need is to lookup a value from sheet1 that should be somewhere in sheet2. Once vlookup has located this value it then needs to go a certain amount of columns accross eg 10 in sheet2 to find another value (as a normal vlookup does). Now I cant figure it out: IF the value in sheet2 in this cell matches a value in sheet1 then I need the formula to return a 1, if it does not match then I need it to return a 0. I cant quite figure out how the formula would go, with nested functions etc

If anyone could assist that would be great as its driving me mad

launcher
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
vlookup question Tony G Excel 9 03-28-2009 11:16 PM
Using Vlookup & IF together Vlookup and If statement problem bunnygum Excel 1 03-24-2009 05:10 AM

Other Forums: Access Forums

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


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