Forum Discussion
Lookup columns + formula
Hello, I am attempting to do the following
- I have 5 columns of data
| A | B | C | D | E |
| New Word | New Score | Old Word | Old Score | Lookup (I did a lookup if the Old words exist in the New word list, then return the New Word) - at least I think I did this right
=IFNA(VLOOKUP(A2:A3795,D2:D2484,1,FALSE),"NEW WORD Column A") |
| Apple | 61.29 | Banana | 49.63 | Pears |
| Pears | 57.53 | Strawberry | 69.78 | Cantaloupe |
|
From Column E - I am looking to calculate the % or difference in the Old Score (E) to the New Score (B). I am using =imsub for this.
Thanks!
