Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link cells to pull specific data
Hi,
Spreadsheet 1 has column B with Network number, C with Name, D with Description. In spreadsheet 2 , in column A i will put Network number and I want the Name and Description from Spreadsheet 1 to be pulled into Sheet 2 in columns B&C. Please let me know. Thanks for your help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link cells to pull specific data
Hi,
Looks like =VLOOKUP(A2,Sheet1!B1:D100,2,False) and =VLOOKUP(A2,Sheet1!B1:D100,3,False) If this helps, please click the Yes button Cheers, Shane Devenshire "NM" wrote: Hi, Spreadsheet 1 has column B with Network number, C with Name, D with Description. In spreadsheet 2 , in column A i will put Network number and I want the Name and Description from Spreadsheet 1 to be pulled into Sheet 2 in columns B&C. Please let me know. Thanks for your help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link cells to pull specific data
Thanks Shane! I am grateful to you for your help.
"Shane Devenshire" wrote: Hi, Looks like =VLOOKUP(A2,Sheet1!B1:D100,2,False) and =VLOOKUP(A2,Sheet1!B1:D100,3,False) If this helps, please click the Yes button Cheers, Shane Devenshire "NM" wrote: Hi, Spreadsheet 1 has column B with Network number, C with Name, D with Description. In spreadsheet 2 , in column A i will put Network number and I want the Name and Description from Spreadsheet 1 to be pulled into Sheet 2 in columns B&C. Please let me know. Thanks for your help. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link cells to pull specific data
Hi Shane,
I'm using the same Vlookup formula in a different sheet. i'm getting a #N/A error! The calculation steps show erroe at the 'lookup_value'.I've tried by best but cannot work through it.Can you please let me know how to get rid of this. Thanks! "Shane Devenshire" wrote: Hi, Looks like =VLOOKUP(A2,Sheet1!B1:D100,2,False) and =VLOOKUP(A2,Sheet1!B1:D100,3,False) If this helps, please click the Yes button Cheers, Shane Devenshire "NM" wrote: Hi, Spreadsheet 1 has column B with Network number, C with Name, D with Description. In spreadsheet 2 , in column A i will put Network number and I want the Name and Description from Spreadsheet 1 to be pulled into Sheet 2 in columns B&C. Please let me know. Thanks for your help. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link cells to pull specific data
Are any of the network numbers atually text and not real numbers? You could
test it by finding the 2 cells that should match and just seeing if they actually do, for example: Sheet1!B7 is a network number that you know should match to Sheet3!A5 so test it, somewhere in the workbook type: =(Sheet1!B7=Sheet3!A5) ... note, if you test it on sheet1 or sheet3 you do not need to reference it in the formula You could then also test for numbers =ISNUMBER(Sheet1!B7) =ISNUMBER(Sheet3!A5) -- ** John C ** "NM" wrote: Hi Shane, I'm using the same Vlookup formula in a different sheet. i'm getting a #N/A error! The calculation steps show erroe at the 'lookup_value'.I've tried by best but cannot work through it.Can you please let me know how to get rid of this. Thanks! "Shane Devenshire" wrote: Hi, Looks like =VLOOKUP(A2,Sheet1!B1:D100,2,False) and =VLOOKUP(A2,Sheet1!B1:D100,3,False) If this helps, please click the Yes button Cheers, Shane Devenshire "NM" wrote: Hi, Spreadsheet 1 has column B with Network number, C with Name, D with Description. In spreadsheet 2 , in column A i will put Network number and I want the Name and Description from Spreadsheet 1 to be pulled into Sheet 2 in columns B&C. Please let me know. Thanks for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I link cells in 1 spreadsheet to Specific cells in another | Excel Discussion (Misc queries) | |||
Setting formulas to pull data from a specific character spacing... | Excel Worksheet Functions | |||
How do I pull a specific name based on a specific value from mult. | Excel Worksheet Functions | |||
Excel pull data based upon one specific word between two date | Excel Worksheet Functions | |||
pull data for a company with data in diff cells multiple wrkshts | Excel Worksheet Functions |