Microsoft Office Forums - View Single Post - Pasting new data and formulas stop working

Thread: Pasting new data and formulas stop working

View Single Post

Old

07-07-2017, 12:24 AM

Kubi

Kubi is offline

Kubi uses Windows XP

Windows XP Kubi uses Office XP

Kubi uses Office XP

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!A1

10,4,0)

Reply With Quote