Hi,
I'm a first timer to the forum posts so I hope I do this right.
I currently have 2 worksheets say Sheet1 and Sheet 2
Sheet 1 contains a large amount of data under 5 headings:
A Name
B Item
C Value
D Qty
E Status
There are multiple rows for each persons name that contains different data under the other headings.
In the second sheet I am wanting to have these same heading however be able to have a cell say A1 that is a valadation list for names and A2 also a valadation list but for Status . Once this name and status has been selected I want to use a 2 crieria Vlookup function to poulate the table below with all rows containing the person's name and the status.
I have tried different vlookups, UDFs and macros but can't seem to get what I need.
Any help is helpful
Bookmarks