Hi,
OK, I'm a numpty at this and have done my best to find the answer already! I think this is a VLOOK formula that's needed but I try and try and don't get the result. If anyone can help, I'm certainly grateful.
I have a list of clients in sheet1 with data in columns A - I
Each row has data all cells. There are 30000+ rows so automating this is a must.
Column C contains a customer reference.
In sheet2 I have a single column of selected customer reference numbers and need to extract just the rows (all columns) in sheet1 that contain that list of numbers, but not the ones that dont. These numbers are the same as C in sheet1 but just a fairly random selection rather than all of them. Don't mind where I extract them too but into Sheet3 will be nice.
I'm missing something really obvious?
Help appreciated if there is a solution before I begin manually finding, selecting, copying and pasting the rows manually as need to pull out 7000 of them.
Lone
Bookmarks