View Single Post
 
Old 01-17-2017, 10:48 AM
jeffreybrown jeffreybrown is offline Windows Vista Office 2007
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

If you are looking for other options...

You could also use in the example xor posted...

D3 =IFERROR(HLOOKUP($B$3,$K$3:$L$8,ROW(A2),0),"")
Reply With Quote