# POSITION OF A VALUE

#### hmsbablu

##### New Member
Kindly help me with a code or formula to find the solution for the following. I am a newbie to excel and beginner, here is my problem:

Data in sheet 1:

COLUMN A: SCRIP NAME COLUMN B: POSITION

x 1
y 2
z 3

Data in sheet 2:

COLUMN A: SCRIP NAME COLUMN B: POSITION

x 2
y 1
z 3

I want the result in the Sheet 3 as follows:

COLUMN A:[Scrip name] COLUMN B[Position in sheet1]: COLUMN C: [Position in sheet2]

x 1 2
y 2 1
z 3 3

and the number of List may vary from sheet to sheet, but the unique in both sheets by scrip name should be in the sheet 3.

Kindly someone here help me, please.

### Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use \$ signs: \$V\$2:\$Z\$99 will always point to V2:Z99, even after copying

#### NBVC

##### Well-known Member
You could use Vlookup()

e.g. for Sheet 1 info =Vlookup(A2,Sheet1!\$A\$2:\$B\$1000,2,FALSE)

for sheet 2 info =Vlookup(A2,Sheet2!\$A\$2:\$B\$1000,2,FALSE)

where A2 contains the first lookup value.

adjust ranges to suit and copy formulas down.

#### hmsbablu

##### New Member
THANKS NBVC

That really worked exactly. similarly is there any code.

Replies
0
Views
39
Replies
15
Views
230
Replies
2
Views
38
Replies
5
Views
104
Replies
2
Views
136