Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
transfer data cell from another work sheet
I want to input a value in one cell and get the info from another cell in
another worksheet, eg I put 1234 it will give a name associate with that number |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
transfer data cell from another work sheet
Hi,
Take a look at the function VLOOKUP =VLOOKUP(A1,Table,3,FALSE) would look up the value in A1 , 1234 in a range you designate on another sheet, I called it Table, 3 tells it I want the associated information from the third column of the Table range where the first column was the column containing the number I was looking up. False means I want an exact match. If this helps, please click the Yes button. Cheers, Shane Devenshire "MDAM" wrote I want to input a value in one cell and get the info from another cell in another worksheet, eg I put 1234 it will give a name associate with that number |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
transfer data cell from another work sheet
Hi,
Please read up on the VLOOKUP() function in Excel's Help menu -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "MDAM" wrote in message ... I want to input a value in one cell and get the info from another cell in another worksheet, eg I put 1234 it will give a name associate with that number |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transfer cell data from sheet to sheet? | Excel Discussion (Misc queries) | |||
How do i transfer cell data from one sheet to the other in Excel | New Users to Excel | |||
How do i get my data to transfer to another work sheet? | Excel Discussion (Misc queries) | |||
transfer an excel work sheet to Paint | Excel Discussion (Misc queries) | |||
transfer an excel work sheet to Paint | Excel Discussion (Misc queries) |