Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I've been reading for the last hour or so thru the group and have tried
to modify some of the formulas I thought might help me, but I'm just not getting it. Sheet1 contains names, addresses, reference numbers (Column M), etc. Sheet2 contains codes (Column A) and reference numbers (Column H). I want to have a column in Sheet1 that matches up the reference numbers and then either links to the exact cell in Sheet2 OR pulls in Sheet2's code. One difficulty might be that the reference numbers (Column M) in Sheet1 also contain various other info/numbers. For example: In Spread1 (Column M140), we have: "8489498 2/07 54978 - link 3" whereas, Spread2 (Column H3380) would have ONLY the matching number: "8489498." I hope I've made this clear. Not exactly sure what questions to ask so, if you can help, I'll answer any question asap. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Double and Multiple Lookup Using the MATCH Function | Excel Worksheet Functions | |||
Formula to Link to Specific List on Another Worksheet | Excel Worksheet Functions | |||
How can I make the reference link match the new formatting of its | Excel Discussion (Misc queries) | |||
Paste Link - retaining formatting | Excel Discussion (Misc queries) | |||
index & match with links for updating to other workbooks | Excel Worksheet Functions |