Vlookup error

[Carolyn]

I am having problems with setting up a vlookup table using two
different worksheets in the same workbook. I have tried it many
different ways and either end up with N/A or REF error. One sheet is
named master and the other is data. I am trying to update a field
related to number of items.

Data sheet is:

A B C D
12 Name City 5

I want the value in column D to update into the field in the master
sheet. The master sheet is:

A B C
12 Name (Want the 5 in data sheet)

I have been using =vlookup(a1,data!a$1:a$200,4,0)

Can anyone please help?

Thanks,
Carolyn

 

[Gord Dibben]

Carolyn

Change your table range to include all four columns.

Data!A1200

Gord Dibben Excel MVP

 

[Domenic]

Hi Carolyn,

Try,

=VLOOKUP(A1,Data!$A$1:$D$200,4,0)

Hope this helps!