Thread: VLook Up Changing the Character
View Single Post
 
Old 08-18-2020, 11:49 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default
Supposing tour range is A1:B100, try something like

=INDEX($B$1:$B$100,SUMPRODUCT(--ISNUMBER(FIND(your_lookup_value,$A$1:$A$100))*ROWS (A1:B100)))
Reply With Quote