itsgrady
Board Regular
- Joined
- Sep 11, 2022
- Messages
- 115
- Office Version
- 2021
- Platform
- Windows
- MacOS
Not sure if the formulas I used is best why to view the data, but I would like an easy way to update the information as well. The first two rows are used to review two rows of data at a time and it works well, but I have a few questions.
Three questions about the table below.
Three questions about the table below.
- In the Last column I would like to view only the information after the " / " to crate the link.
- When you type the Profile Number in the first cell it returns information from the bottom. I have around 10,000 rows of information. Is there a way to update the information and the table below will update--not sure it is possible. Maybe a fast way to navigate to the information to update it.
- Sometimes when I type the Profile Number in the first cell it does not return the information. I have to copy the number and paste it in the cell for it to return the information. Sometimes I have to paste it a few times to get it to update.
Running List.xlsm | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
AG | AH | AI | AJ | AK | AL | AM | AN | |||
6 | Profile Number | Type | Description | Initials | Unit | Code | Company | Link | ||
7 | 537079 | 12th | Lives with Father | Water | A | WIN | Walmart | Open Profile Profile | ||
8 | 640772 | 11th | Will always | Water | B | 123 | Walmart | Open Profile Profile | ||
9 | ||||||||||
10 | Profile General Classification | |||||||||
11 | Profile Number | Type | Description | Rinse Agent | Unit | Code | Company | Link | ||
12 | 537079 | 12th | Lives with Father | Water | A | WIN | Walmart | Profiles/537079.PDF | ||
13 | 640772 | 11th | Will always | Water | B | 123 | Walmart | Profiles/640772.PDF | ||
14 | 1290455 | 10th | Need a friend | Water | C | 231 | Walmart | Profiles/1290455.PDF | ||
15 | 155140-000 | 5th | Bee stings | Toluene | D | 1W2 | Walmart | Profiles/155140-000.PDF | ||
16 | 178226 | 4th | Mom is a teacher | A | 2NM | Walmart | Profiles/178226.PDF | |||
17 | 1330221 | 3rd | Walmaert | Water | B | 124 | Walmart | Profiles/1330221.PDF | ||
18 | 1330221 | 12th | REACTIVE | Toluene | C | NNN | Walmart | Profiles/1330221.PDF | ||
19 | 1440028 | 9th | Just moved here | Water | D | N23 | Walmart | Profiles/1440028.PDF | ||
20 | 12797 | 8th | 5th grade was tough | Water | A | KJ9 | Walmart | Profiles/12797.PDF | ||
21 | 12802 | 10th | No friends | Water | B | 2PK | Walmart | Profiles/12802.PDF | ||
22 | 403558 | 11th | 12th Grade | C | 2O0 | Walmart | Profiles/403558.PDF | |||
23 | 1515969 | 10th | Happy | Water | D | GET | Walmart | Profiles/1515969.PDF | ||
Sheet3 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
AH7 | AH7 | =IFERROR(IF(VLOOKUP($AG$7,School12,2,FALSE)="","No Data",VLOOKUP($AG$7,School12,2,FALSE)),"") |
AI7 | AI7 | =IFERROR(IF(VLOOKUP($AG$7,School12,3,FALSE)="","No Data",VLOOKUP($AG$7,School12,3,FALSE)),"") |
AJ7 | AJ7 | =IFERROR(IF(VLOOKUP($AG$7,School12,4,FALSE)="","No Data",VLOOKUP($AG$7,School12,4,FALSE)),"") |
AK7 | AK7 | =IFERROR(IF(VLOOKUP($AG$7,School12,5,FALSE)="","No Data",VLOOKUP($AG$7,School12,5,FALSE)),"") |
AL7 | AL7 | =IFERROR(IF(VLOOKUP($AG$7,School12,6,FALSE)="","No Data",VLOOKUP($AG$7,School12,6,FALSE)),"") |
AM7 | AM7 | =IFERROR(IF(VLOOKUP($AG$7,School12,7,FALSE)="","No Data",VLOOKUP($AG$7,School12,7,FALSE)),"") |
AN7 | AN7 | =IFERROR(HYPERLINK(VLOOKUP(AG7,School12,8,FALSE),"Open " & LEFT(VLOOKUP(AG7,School12,8,FALSE),7) & " Profile"),"") |
AH8 | AH8 | =IFERROR(IF(VLOOKUP($AG$8,School12,2,FALSE)="","No Data",VLOOKUP($AG$8,School12,2,FALSE)),"") |
AI8 | AI8 | =IFERROR(IF(VLOOKUP($AG$8,School12,3,FALSE)="","No Data",VLOOKUP($AG$8,School12,3,FALSE)),"") |
AJ8 | AJ8 | =IFERROR(IF(VLOOKUP($AG$8,School12,4,FALSE)="","No Data",VLOOKUP($AG$8,School12,4,FALSE)),"") |
AK8 | AK8 | =IFERROR(IF(VLOOKUP($AG$8,School12,5,FALSE)="","No Data",VLOOKUP($AG$8,School12,5,FALSE)),"") |
AL8 | AL8 | =IFERROR(IF(VLOOKUP($AG$8,School12,6,FALSE)="","No Data",VLOOKUP($AG$8,School12,6,FALSE)),"") |
AM8 | AM8 | =IFERROR(IF(VLOOKUP($AG$8,School12,7,FALSE)="","No Data",VLOOKUP($AG$8,School12,7,FALSE)),"") |
AN8 | AN8 | =IFERROR(HYPERLINK(VLOOKUP(AG8,ProfileTable,8,FALSE),"Open " & LEFT(VLOOKUP(AG8,ProfileTable,8,FALSE),7) & " Profile"),"") |
AN12:AN23 | AN12 | ="Profiles/"&AG12&".PDF" |
Named Ranges | ||
---|---|---|
Name | Refers To | Cells |
School12 | =Sheet3!$AG$12:$AN$23 | AN7, AH7:AM8, AN12 |