Hi, I am trying to do a lookup from column A on sheet A and against the columns A-C on sheet B, to return the data in columns G-I on sheet B as A relates to G, B relates to H and C relates to I.
The sample I killed the formulas on sheet B but they are all sequence formulas so the numbers are dynamic and spill down depending on other criteria. That being said, columns A-C are all related to each other so there will be no duplicate numbers in either column.
I'm not sure if this makes sense but if anyone can assist, that would be great. I would also like to avoid VBA unless its super simple.
Bookmarks