| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ho to pull inmormation from a list?
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Ho to pull inmormation from a list?
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 On Apr 20, 4:30 pm, Start-Struck <Start- wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| delete from pull down list | Excel Discussion (Misc queries) | |||
| How do I display fractions in a pull down list? | Excel Discussion (Misc queries) | |||
| How do I set up a cell with a pull down list? | Excel Discussion (Misc queries) | |||
| How do I get a calendar pull down list in Excel? | Excel Discussion (Misc queries) | |||
| Pull unique names for drop down list | Excel Discussion (Misc queries) | |||
Hybrid Mode
