LookUp

  • Thread starter Thread starter Joel
  • Start date Start date
J

Joel

Lookup

I have a work book that holds information on people like
(ID, Name, Salary Etc)
I want to be able to go to another sheet in that workbook
and type in say the ID Number and it automatically adds
all the info to that sheet

Thanks in advance Joel
 
=VLOOKUP(A1,Sheet2!$A$1:$H$100,2,FALSE)

etc. Change the 2, etc to the lookup column.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Hi,

Lets say your data is in sheet 1 in the range A1:D100, use this is
another sheet where A1 has the ID number

=VLOOKUP(A1,Sheet1!A1:D100,2,FALSE)

Regards

Govind.
 
I only puts in the last name I want it to put in the
salary Firstname under the right colums etc
 
Hi,

The formula assumes that you input the ID in cell A1.The formula can be
in B1 or C1 or D1 as you wish.

Regards

Govind.

I Keep getting N/A where should I put the Formulea
I type the numer I want in ID
Click to expand...

.. looking out across Poole Harbour to the Purbecks
 
Thank you

Can I ask how I get it to put in the othe info from the
same line as the ID number
 
When I type in the ID Numer I want to automically put the
information from that line

For example I have a row with the following headings

ID Lastname FirstName Salary

if I type in the the Id Number i want it to put the First
Name, Surname, Salary etc

So basically I want to put in that entire row

Regards Joel
 
Hi,

Lets say you enter ID in cell A2 of sheet 2, type this formulas:

=VLOOKUP(A2,Sheet1!A1:D100,2,FALSE) in Cell B2
=VLOOKUP(A1,Sheet1!A1:D100,3,FALSE) in Cell C2
=VLOOKUP(A1,Sheet1!A1:D100,4,FALSE) in Cell D2

etc.

Change the range A1:D100 to the area where you have the source range.

REgards

Govind.
 
Hi Joel,

Here's one way of doing it...

Assuming that your headers are in Row 1, and your data starts in Row 2:

1) Select three cells somewhere after your table. For this example,
let's select B15 to D15. These cells should now be highlighted.

2) Press =

3) Enter the following array formula, which must be entered using
CONTROL+SHIFT+ENTER:

=VLOOKUP(A15,A2:D100,{2,3,4},0)

where A15 contains the ID of interest

adjust the range accordingly

Hope this helps!
 
I am using the following code =VLOOKUP(B5,PlayersSheet!
A5:D385,2,FALSE in Cell D5

I get an error

Joel

Please help
 
Hi,

Have you entered the employee id on cell B5 ?

Can you tell me how your data is structured. What is there in the four
columns of sheet "Playerssheet" ?

Regards

Govind.
 
Dear Govind

In answer to your first question, yes it is B5.

It is split into 3 Colums ID No. Name Team Price
A5 B5 C5 D5
 
Hi,

So lets say in the next sheet, you want to enter just the ID and get all
other info, structure your next sheet like this & use the following
formulaes:

Column B Column C Column D Column E

Lets say for example in cell B5 you enter the id

Then in C5 use the formula =VLOOKUP(B5,PlayersSheet!
In D5 use the formula =VLOOKUP(B5,PlayersSheet!
In E5 use the formula =VLOOKUP(B5,PlayersSheet!
and copy the formulas and paste it down for all the other cells in their
respective columns.

Regards

Govind.
 
Cheers Mate

I am note sure this helps I only want to have to type in
the ID number then it fills in the other cells with the
corrisponding data
 
Hi,

Thanks. Can you specify clearly what is your requirement? In this case
also when you type your ID,the other data will be populated
automatically due to the formulas

Regards

Govind.
 
Back
Top