Hello From Steved
Col B Col C Col D in Sheet1
4024 001 3.25
Col A Col B Col C in Sheet2
001 3.25
What is formula is required to pickup
4024 in Col B Sheet1 and put it in Col A Sheet2
please.
Thankyou.
-----Original Message-----
Hi Steved,
For vlookup, you need to have a common field which is
present both in
Sheet 1 and Sheet 2.
To do ths,arrange your sheets like this.
Sheet 1 - schools database
Column A has an field and Column B , c and D have data.
column A could
be student number for Eg
Sheet 2 - Data sort
Enter the student number for which you are going to
lookup in column A.
Then in column B(say cell B2) , use this formula
= VLOOKUP(A2,'Schools Database'!A10:D2000, 2, false)
This will return the value in column B of sheet 1 for
the same student
number.
To return column C of sheet 1, use
= VLOOKUP(A2,'Schools Database'!A10:D2000, 3, false)
and accordingly.
Thanks
Govind.
Steved wrote:
Hello from SteveD
=VLOOKUP(B2,'Schools Database'!C10:C2000,C2,'Schools
Database'!D10:D2000)
is putting #REF! in the Cell.
-----Original Message-----
Hello from Steved
I've two identical worksheets Labeled Sheet1 and Sheet2
Sheet1 ColB, ColC, ColD
Sheet2 ColA, ColB, ColC
How do I write a formula Please to update sheet2 ColA
from Sheet1 ColB,
Sheet1 ColC, ColD Are the same Values in Sheet2 ColB,
ColC
Thankyou.
.
.
|