When considering this formula =VLOOKUP(B3,Master!$A$3:$O$4180,3,FALSE) the
,3, refers to the second column to the right of a reference column on the
Master sheet.

Using this formula and the following table where column C is the reference
column and the ,3, refers to column €˜E; is there a way to refer to a column
to the left of the reference column i.e. column €˜A?

MASTER sheet
A B C D E F
Ambeault Chelsea 1 Ambeault Kyla RR2
Anderson Cache 2 Anderson Shelley 419 Riverpark Dr
Ansell Jaime 3 Ansell Dave 9609-100 Street
Ansell Sean 4 Ansell Dave 3937-51 Street
Antoniuk Braden 5 Antoniuk Chantal 8146-94 Avenue
Arbuckle Jay 6 Arbuckle Gail 10 Westwood Wynd
Banh Shally 7 Banh Tien 10 Westwood Wynd
Barbour Michael 8 Barbour Dianna 438 Riverpark Dr

Suggestions are appreciated

Thanks
ksean