Hi All,
I have a file which i use a some help on. I'll explain on how it functions first. On the tab names sheet2 there are is the report which the data needs to be extracted from. We will need to locate the location first for example 1000 and then look up the type called "main".once these 2 info has been referenced the name that is indicated on column D needs to be brought over to the tab called Sheet1 and input in column E called names. it would be helpful if it can be coded into vba on the sheet as I am looking at quite a number of rows of data.
I've added some samples with expected results.
Bookmarks