Update one Worksheet from Another

[OldDog]

Hi,

I want to be able to update a worksheet by looking up data from another
worksheet. in other words;

If Servername in Worksheet A column A equals Servername in Worksheet B
Column C then copy serial number from Worksheet B column D to Worksheet
A column D.

Thanks in advance for any help.

OldDog

 

[JulieD]

Hi

you can use the VLOOKUP function to achieve this.

in Worksheet A column D type
=VLOOKUP(A1,WorksheetB!$C$1:$D$1000,2,0)
this will return the information from column D of Worksheet B where there is
an exact match between the data in column A of the current sheet and column
C of worksheet B.

Hope this helps
Cheers
JulieD

 

[OldDog]

Thanks for the reply. Seems to want to pull the information from the
wrong cell. I will continue to work with it.

OldDog

 

[JulieD]

what are your ranges (for worksheet B)?
what is your exact formula?

cheers
JulieD