Function

  • Thread starter Thread starter Tracey181
  • Start date Start date
T

Tracey181

Hi

Please can someone help me. Here is what i have been trying to do:

I have 2 worksheets, in 1 worksheet i have a list of numerical code
C10 :C60 on the other worksheet i have the identical list of code
with corresponding codes. C10:C60 & D10:D60 respectively.

I want to be able to pull the corresponding code into worksheet 2 i
the 2 codes match from the identical lists on each worksheet.

I hope i have explained it.

Please Help

Trace
 
use the vlookup function

on the first sheet in D10 (assuming this is where you want the codes)

=VLOOKUP(c10,sheet2!c$10:sheet2!$d$60,2,FALSE)

and copy this down the column

Regards,

Neal
 
Hi Tracey,
If I have understood you correctly you need to use
the "Vlookup" function....

If sheet1 contains the codes in C10:C60 and you want to
pull in the corresponding codes from sheet2...then in
sheet1 in D10 =VLOOKUP(C10,Sheet2!C10:D14,2)

Does that make sense? If not, refer to "vlookup" in help
and that might do a better job.

:)
 
Tracey181 said:
Hi

Please can someone help me. Here is what i have been trying to do:

I have 2 worksheets, in 1 worksheet i have a list of numerical codes
C10 :C60 on the other worksheet i have the identical list of codes
with corresponding codes. C10:C60 & D10:D60 respectively.

I want to be able to pull the corresponding code into worksheet 2 if
the 2 codes match from the identical lists on each worksheet.

I hope i have explained it.

Please Help

Tracey
Click to expand...

If I understand correctly, in D10 of Sheet1 you need the formula
=VLOOKUP(C10,Sheet2!$C$10:$D$60,2,0)
and you then copy this formula down as far as D60.
(I may not have the sheet names correct, and I'm confused as to which is
which, but you may be able to sort this out yourself!)
 
Back
Top