Ho to pull inmormation from a list?

S

Start-Struck

I have a data sheet on one tab and I need to be able to put in information in
'A1' and in 'C1' I need what is beside that information in the data sheet.
So in the data sheet i can have 12 and then in the line beside it it sayes
54.2. I need the 54.2 to go in 'C1' on the other sheet. the data sheet has
about 1000 items in it.
 
P

Pete_UK

Try this in C1:

=VLOOKUP(A1,data!A$1:B$1000,2,0)

This assumes your data is in A1:B1000 of the data sheet - adjust as
necessary.

Hope this helps.

Pete
 
Top