Microsoft Office Forums - View Single Post - Vlookup - if the result is blank then enter a formula

Thread: Vlookup - if the result is blank then enter a formula

View Single Post

Old

03-01-2019, 03:09 AM

bosco_yip

bosco_yip is offline

bosco_yip uses Windows 10

Windows 10 bosco_yip uses Office 2016

bosco_yip uses Office 2016

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