For example if I am trying to sort a list of dates that proposals are submitted. If multiple proposals are submitted on the same date, sorting it and using VLOOKUP will only repeat the first proposal that it gets to rather than showing me both.
What if there are values that repeat?
You need to create a %26quot;composite key%26quot;. Since date isn%26#039;t unique, you need to create a unique field to search on. Maybe it%26#039;s a combination of date and client or something.
Add a column that combines those two fields (something like %26quot;=A1 %26amp; B1%26quot;) on both sheets you%26#039;re looking at, and do the vlookup on that field.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment