Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 07-07-2017, 12:24 AM
Kubi Kubi is offline Pasting new data and formulas stop working Windows XP Pasting new data and formulas stop working Office XP
Advanced Beginner
 
Join Date: May 2017
Posts: 34
Kubi is on a distinguished road
Default

are you just wanting to return a value from sheet 1 without looking through it? perhaps try using a VLOOKUP for example

=VLOOKUP(A6,Sheet1!A110,4,0)
Reply With Quote
 

Tags
formula, if-statement, paste



Similar Threads
Thread Thread Starter Forum Replies Last Post
Pasting new data and formulas stop working Workbook Stop Working When Run VBA GeoKoro13 Excel Programming 1 12-01-2016 04:03 AM
VBA to gather data from one workbook and pasting it in a data set lwbarnes Excel Programming 1 11-02-2016 07:05 PM
All Office products stop working lethlean Office 1 05-18-2013 07:07 AM
Save As cause app to stop working rafterman Word 1 03-04-2013 11:20 PM
GIF's stop working Kwarior PowerPoint 3 03-17-2010 09:59 PM

Other Forums: Access Forums

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