Hi!
Just hoping to get some help, my skills in excel are elementary.
I have a huge table of data and I'm hoping to extract certain information to another sheet, and for it to automatically update.
I am unable to upload a table as its for work and all info is sensitive, so I'll try my best to explain using column names.
My defining column is column H. If data in the cell = X exactly, then I'd like it to copy some of the information from that row too, multiple columns: A, B, C, D, E, F, G, I and RZ (and H). If data does not = X, then skip that row.
I did some digging and experimented with VLOOKUP and ZLOOKUP however I am unsure how to implement copying the rest of the data.
All help is appreciated!
Bookmarks