I'm using expense account names to look up the actual numbers each month, but there are some expense account names that are duplicated in different cost centers. is there a way to have my vlookup choose the 2nd or 3rd value for a name instead of the first one it sees? I wish my report had specific account numbers but it doesn't. below is an example of what I currently have:
Cellular Telephone is the expense account and the formula is =VLOOKUP($B231,'Rolling Trend'!$A:$M,9,0)
in just this example I have Cellular Telephone appearing in row 608 and the next one in 613 but it will vary with each entity so I'm hoping there's a way to have it ignore the first one and grab the 2nd one
Cellular Telephone is the expense account and the formula is =VLOOKUP($B231,'Rolling Trend'!$A:$M,9,0)
in just this example I have Cellular Telephone appearing in row 608 and the next one in 613 but it will vary with each entity so I'm hoping there's a way to have it ignore the first one and grab the 2nd one