Vlookup help

[aluzio]

Hi all,

I have 2 worksheets and I'm trying to do a vlookup from one sheet to another. I have to enter the formula that will bring over the information onto the other worksheet. Any ideas?

Thanks

[NBVC]

Have you read Vlookup help in Excel's help files?

That should put you in the right direction...

If not, we would need more details as to actual sheet/column/cell references...

[aluzio]

Hi
Ok 1st worksheet is called customers with:
Column a:customer number
column b:custmer name
column c:address
column d: home phone

worksheet 2 is called workorders
this has the same columns but no details
I have to do vlookup on this worksheet so that when i enter the customer number it will automatically fill in all the colums details.
So far i think I have to do this:
Vlookup (a2:customers!$a$2$) ??
Help!!!

[ratcat]

G'day aluzio,

Try this

=vlookup(A2,customers!A1:D1000,2,false)

Lookup value = A2

Table array = customers!A1:D1000

Col index num = 2

Eg

1 = Column a:customer number
2 = column b:custmer name
3 = column c:address
4 = column d: home phone

Range lookup = false
(The range lookup is a logical value: to find the closest match in the first column ((sorted in ascending order)) = True or omitted; to find an exact match = false.)

Hope this helps