hi guys,

good day.

i have been doing this program for two days now, and i know i'm doing bad.

i have a little knowledge about VBA, all i do is get the codes from searching from google.

well, this is what i want to do:

search and compare all items under column Letter (column B) and get all corresponding number under column Number (Column A) be reflected to column Number1~2(Column D~E).

i tried doing a nested if statement inside a for-next, but i can't do it right, then i tried the find function of excel, but it seems to be more complicated.

i hope someone could help me on this.

this is a sample format, under Number1 and Number2 columns are the supposedly outputs.

number letter Number1 Number2
1 a 1 7
2 b 2
3 c 3 6
4 d 4 5
5 d 5 4
6 c 6
7 b 7 2
find.xls