Deciphering a number and placing the archived number

[khank]

On Workbook 8 (attached) is the first worksheet entitled "REFERENCE", on that page I have a list of archived numbers.

On Sheet2 - Column A there is a list of numbers which are updated everyday.

What would the coding be to decipher Sheet2 Column A by referring back to "REFERENCE" sheet Column A and place that number in Sheet2 Column B, so on and so forth for all the numbers.

[venkat1926]

in the sheet "reference" in B1 this formula
=VLOOKUP(A1,Sheet2!$A$1:$B$10,2,0)
copy B1 down.

there is no 007 in sheet 2 that is why "#N/A" (not available)

is this what you wnat

[khank]

Not really. Close. On Sheet2 A1 there is 700, on the "REFERENCE" sheet there is A1 007. Both contain the same numbers but in different order.

On Sheet2 B1 I want to "lookup" and place the correlated number. (It could be either 700, 070, 007). The number I want "placed" is from the "REFERENCE" sheet which would be "007".

I don't know if it is a "VLOOKUP" function or a "ISERROR" type function???

[khank]

Recommendation?

I'm using the following code in Column AK1:

{=VLOOKUP(AJ1,$Z$1:$Z$220,2,0)}

I'm getting a #REF! in column AK if the AJ:1 is a match in column Z, if the number doesn't match I'm getting a #N/A.

This close to what I'm wanting to achieve.

Example: in column AJ1 the number is 123, but in column Z1:Z220 the number is 231 - Logically YES the numbers 1-2-3 appear but in the order of 2-3-1, so then in AK1 the answer would be YES but in the order of 231 number and that is the number I what to placed in AK1.

What am I missing?

[NBVC]

Try:

Please Login or Register  to view this content.

[khank]

Again thank you for all your help. The coding works like a charm.