|
|
|||||||
|
|
Thread Tools | Display Modes |
|
#2
11-28-2018, 12:02 AM
|
|||
|
|||
The info on other worksheet must be in table (all info about particular person is single row, the key column (e.g. name) must be leftmost one.
You can get any info for this person from persons table (e.g. part name) using VLOOKUP() function. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 How to write a formula to simplify the work?
|
Learner7 | Excel | 1 | 11-19-2015 12:46 AM |
|
Is there a shorter way to write this formula?
|
babs1234 | Excel | 1 | 03-09-2015 12:16 AM |
|
Is it possible part of specific text section not to be printed?
|
deboer | Word | 11 | 05-25-2014 01:57 PM |
| Is it possible to write down a number starting with zero in excel cell? | Rahmat_uk20 | Excel | 3 | 06-08-2012 02:26 AM |
|
How can I write the following (whole) formula in a single cell?
|
Learner7 | Excel | 1 | 07-19-2010 10:06 AM |
Windows 8 
Office 2016
Threaded Mode