Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 08-10-2017, 05:14 AM
vicmar vicmar is offline Vlookup in another worksheet Windows 7 64bit Vlookup in another worksheet Office 2010 64bit
Novice
Vlookup in another worksheet
 
Join Date: Aug 2017
Posts: 24
vicmar is on a distinguished road
Default

Hi thank for your response. What do you mean create list in the column of master list?

the name of the sheet?

What Im trying to do is for example in Sheet A Column E should be equal in Master List column B if Master List Column F is equal to Sheet A Column B.

I try this formula but its not working in other sheets:

=IF(a!B3='Master List'!F3,'Master List'!B3,"")
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
worksheet compatibility issues using VLOOKUP gringodegolfo Excel 6 03-23-2016 08:23 PM
Vlookup in another worksheet Appending unique data from one worksheet to existing data on another worksheet EdStockton Excel 1 08-06-2014 11:00 PM
Vlookup in another worksheet How to summarise different worksheet to a summary worksheet samkiewhock Excel 1 09-06-2012 03:34 AM
Vlookup in another worksheet "Auto-populating" data-worksheet to worksheet. meggenm Excel 4 02-04-2012 02:04 AM
Vlookup Karen615 Excel 4 09-12-2011 02:30 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:46 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