Hey Excel friends!
So I have a bit of a different one today that I'm not sure on.
In the below you can see I have written a VLOOKUP with IFS to meet 3 conditions, and it's doing what I want (superseeding each column based on order of vlookup and data that is input in the table)
My worry with this, and as I seem to be experiencing in another worksheet as it's getting bigger is that the VLOOKUP i'm using in a real world scenario is going to another workbook and seems to be gradually slowing my workbook down (freezes very often) and have to wait for it to unfreeze.
The thing with this is that each row I create needs to have the VLOOKUP in as I need the data to be refreshing on each project for a certain number like in my example.
The question is, is there a better way to write this or better formula that will achieve this?
So I have a bit of a different one today that I'm not sure on.
In the below you can see I have written a VLOOKUP with IFS to meet 3 conditions, and it's doing what I want (superseeding each column based on order of vlookup and data that is input in the table)
My worry with this, and as I seem to be experiencing in another worksheet as it's getting bigger is that the VLOOKUP i'm using in a real world scenario is going to another workbook and seems to be gradually slowing my workbook down (freezes very often) and have to wait for it to unfreeze.
The thing with this is that each row I create needs to have the VLOOKUP in as I need the data to be refreshing on each project for a certain number like in my example.
The question is, is there a better way to write this or better formula that will achieve this?
Book1 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | I | J | K | |||
5 | ||||||||||||
6 | Project | Least Important | More Important | Most Important | ||||||||
7 | Project | Importance | ARDENTREWARD | 7 | 10 | |||||||
8 | ARDENTREWARD | 10 | WANTEDLEVEL | 5 | ||||||||
9 | HOTARCH | 8 | 4 | 10 | ||||||||
10 | MANYBAIT | 5 | 6 | 1 | ||||||||
11 | POSSIBLEVOICE | 5 | ||||||||||
12 | UNINTERESTEDYAK | 6 | 3 | |||||||||
13 | FRANKSMASH | 1 | 9 | |||||||||
14 | CARINGDOLL | 3 | 5 | |||||||||
15 | SUPERBSHOES | 7 | 10 | 2 | ||||||||
16 | MESSYROLL | 1 | 4 | |||||||||
17 | DIZZYTHUNDER | |||||||||||
18 | SUBSEQUENTPLANTS | 2 | 7 | 4 | ||||||||
19 | PRIZEDHOPE | 8 | ||||||||||
20 | OUTSTANDINGSMELL | 7 | 7 | |||||||||
21 | UPTIGHTNECK | 6 | 2 | |||||||||
22 | LAMEPARCEL | 4 | 4 | 1 | ||||||||
23 | LAWFULBUBBLE | 1 | 4 | 3 | ||||||||
24 | STEADYENGINE | 2 | 2 | 1 | ||||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C8 | C8 | =IFS(VLOOKUP(B8,H7:K24,4,FALSE),VLOOKUP(B8,H7:K24,4,FALSE),VLOOKUP(B8,H7:K24,3,FALSE),VLOOKUP(B8,H7:K24,3,FALSE),VLOOKUP(B8,H7:K24,2,FALSE),VLOOKUP(B8,H7:K24,2,FALSE)) |