create values based on another worksheet

[TravelingMan]

hey guys,

kinda got stumped here..

I have one worksheet that had suite #'s and dates

worksheet #2 has an invoice date column where each suite has an id# and each charge shows a date.

how would I separate the suite id# and dates... there could be more or less charges between each new suite

i.e.

Invoice date

suite 12345
10/21/2015
10/20/2015
9/23/2015

suite 12367

sheet 1 formula would show.. suite 12345 = suite 345(last 3) and each date would be a charge for that suite.

as you can see.. the suite number changes and starts all new charges.. is there a formula that would be able to be copied down to separate the actual suite and the date?

I have tried IF statements but too many are needed.

Thanks!

 

[Learning To Excel]

I'm not sure I understand what your looking for. But if it is to determine if values in a column have "Suite" in them, and if so take the last three digits, then this could work for you:

=IF(IFERROR(SEARCH("Suite",A1),0)>0,RIGHT(A1,3),"Date")