=VLOOKUP(B3,Master!$A$3:$O$4180,3,FALSE)
What about the '3' ?

The table array is A3:O4180. The 3 refers to the 3rd column relative to the
table array. The 3rd column of the table array is column C, C3:C4180.

Please look ant my 2nd attempt at explaining my delemma.

See my other reply there.

--
Biff
Microsoft Excel MVP


"ksean" wrote in message
...
I understand the parts that you have referenced but I am still missing
something here. What about the '3' ?

Please look ant my 2nd attempt at explaining my delemma.

Thanks
ksean


"T. Valko" wrote:

=VLOOKUP(B3,Master!$A$3:$O$4180,3,FALSE)

Here's what your formula means in plain English:

Look for the value of cell B3 in the range Master!A3:A4180 and, if found,
return the value from the corresponding cell in Master!C3:C4180.

Is that what you had in mind?

--
Biff
Microsoft Excel MVP


"ksean" wrote in message
...
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