Update one Worksheet from Another

  • Thread starter Thread starter OldDog
  • Start date Start date
O

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
 
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
 
Thanks for the reply. Seems to want to pull the information from the
wrong cell. I will continue to work with it.

OldDog
 
Back
Top