Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Vlookup - if the result is blank then enter a formula
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 03-01-2019, 03:09 AM
bosco_yip bosco_yip is offline Vlookup - if the result is blank then enter a formula Windows 10 Vlookup - if the result is blank then enter a formula Office 2016
Novice
  
Join Date: Feb 2019
Location: Singapore
Posts: 7
bosco_yip is on a distinguished road
Default
Try….....................

In "Sheet2" B2, copied across and down :



=IFERROR(1/(1/VLOOKUP($A2,Sheet1!$A$2:$G$6,MATCH(B$1,Sheet1!$A$1 :$G$1,0),0)),A2+5)

Regards
Bosco
Reply With Quote
  #2  
Old 03-01-2019, 07:17 AM
srsev6 srsev6 is offline Vlookup - if the result is blank then enter a formula Windows 10 Vlookup - if the result is blank then enter a formula Office 2013
Novice
Vlookup - if the result is blank then enter a formula 		 
Join Date: Feb 2019
Location: Illinois
Posts: 5
srsev6 is on a distinguished road
Default
Thank you so much bosco_yip!
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
IF Formula not returns result - Help Haha88 Excel 6 02-11-2018 02:07 PM
Vlookup - if the result is blank then enter a formula Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula innkeeper9 Excel 2 09-13-2016 08:59 PM
Vlookup - if the result is blank then enter a formula How To Move Focus From VLOOKUP Result to Report Sheet swindon.expat Excel 2 04-10-2016 12:15 AM
Vlookup - if the result is blank then enter a formula formula, 2 criteria, one result cjdstephenson Excel 4 06-02-2015 09:17 PM
Vlookup - if the result is blank then enter a formula Fetching more than one result with VLookup on multiple sheets lilvillaf Excel 2 06-12-2014 05:39 PM

Other Forums: Access Forums

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