Thread: Help with lookup / v lookup big failure
View Single Post
 
Old 11-04-2022, 07:29 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 948
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
Quote:
Originally Posted by ArviLaanemets View Post
Code:
=OFFSET($A2, SourceSheetName!$A2:$X2, 3, 0)
and copy the formula down. You have what you wanted there!
Shouldn't that OFFSET be VLOOKUP?
Reply With Quote