Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page LOOKUP - Complex lookup with 2 lookups in 1 cell
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 05-04-2016, 08:50 PM
xor xor is offline LOOKUP - Complex lookup with 2 lookups in 1 cell Windows 10 LOOKUP - Complex lookup with 2 lookups in 1 cell Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
If the contents inside the parentheses U(9) always is a digit then put a double minus in front of the MID function.
Reply With Quote
 

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
LOOKUP - Complex lookup with 2 lookups in 1 cell Lookup Tony Singh Excel 3 03-06-2015 11:03 AM
LOOKUP - Complex lookup with 2 lookups in 1 cell LOOKUP and IF FUNCTION midgetmogalle Excel 6 12-06-2013 09:35 AM
Lookup angie.chang Excel 1 07-27-2012 09:45 PM
LOOKUP - Complex lookup with 2 lookups in 1 cell Possible Lookup Karen222 Excel 3 01-10-2012 05:41 AM
LOOKUP - Complex lookup with 2 lookups in 1 cell LookUp aztiguen24 Excel 5 05-24-2011 03:57 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:11 PM.

Contact Us - Privacy Statement - Top

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