Thread: [Solved] Vlookup in another worksheet
View Single Post
 
Old 08-10-2017, 06:14 AM
NBVC's Avatar
NBVC NBVC is offline Windows 10 Office 2013
The Formula Guy
  
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default
Ok.

Try this formula in E3 of each sheet, copied down:

=IFERROR(INDEX(OUT[REF. NO.],MATCH(B3,OUT[INCOMING REF. NO.],0)),"")
Reply With Quote