![]() |
#1
|
|||
|
|||
![]()
Hi
You may have seen my earlier post about invoice numbers. Well I almost have it cracked I just need to copy some data. My layout is similar to this; A B 1 X Y 2 PK00001 3 PK00002 4 PK00003 5 PK00004 6 PK00005 7 PK00006 So, for example, if X (A1) is 1, then I would like the value from A2 (PK00001) to be displayed in B1. Likewise if A1 is 2, then PK00002 and so on. Is there a formula to do this? Thanks |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Is there a way to do this? (automatically enter text based on form data) | TIKKI555 | Word | 0 | 05-26-2010 09:21 AM |
![]() |
trissn | Office | 2 | 02-05-2010 09:27 AM |
![]() |
markg2 | Excel | 4 | 01-07-2010 10:08 AM |
Auto-populate an MS Word table cell with text from a diff cell? | dreamrthts | Word Tables | 0 | 03-20-2009 01:49 PM |
Automatically entering/fill data in cells in Excel 2003 | dipdog | Excel | 0 | 08-17-2006 08:37 AM |