I posted this question yesterday and didn't recieve any responses maybe someone today can help me. I've tried combinations of match and vlookup statements and I can't seem to get anything other that one single value.
I have two excel sheets. On one is a database of information input from a template on the other a sheet that ideally will sort this information. the way I would like it to work is if the database reads:
V1 V2 (value 1 and value 2)
11 A
12 B
13 A
52 A
44 A
65 B
77 A
On the other spread sheet if value A is entered into cell A2 then all the corresponding values to A will read in the B column downward like this:
11
13
52
44
77
Bookmarks