|Formula| Incident number with Vlookup return grouped with ROW () in single cell

[wmunsey81]

I am trying to make an incident column in a log. I have the following formula in the table column cell (is a table so increments):

=VLOOKUP(WHSELocation,Hidden!J2:K33,2,FALSE),ROW()

Of course this is coming back in error.

The idea is it is looking in 'WHSE Location" a name, it matches with it's number, and then I want it grouped with the row number...

Example: 39121, 39122.... or even better.... 3912-1, 3912-2.....

This would be awesome to not only learn but use for future projects.

Thank you in advance!

 

[wmunsey81]

=VLOOKUP(WHSELocation,Hidden!$J$2:$K$33,2,FALSE)

Before everyone says to add the '$' in the lookup, just added.

 

[wmunsey81]

So with no reply, I am guessing it has been missed, cannot be done, or has not been figured out. Also, may be a VBA only answer. Either way, if I figure it out, I will reply with what I find if someone doesn't beat me to it.

 

[wmunsey81]

[COLOR=#242729][FONT=Consolas]=VLOOKUP(WHSELocation,Hidden!$J$2:$K$33,2,FALSE)&"-"&ROW()[/FONT][/COLOR]