1

knowing only date, time, and DRND code (starting TP and numbers), and amount, can i bring the card code to a next to a cell from a different sheet?this is the sheet i want to bring a card number and card numbers

I was trying to do this !could not do vlookup](https://i.stack.imgur.com/nHfAH.png) both sheets has tp numbers, but second sheet which contains card number , u can see the tp over or under the row, so i cant find the right formula to bring the card numbers

noway to interrupt
  • 25
  • 4

1 Answers1

3

you can use the 'vlookup' (or 'index match') to do the match you are already trying and then define that you want the previous row. Something like this, applied to the correct rows in your file:

INDEX(E:E,MATCH(B3,D:D,0)-1)

Note the "-1" which is the condition that defines that you always want the previous row.

Bruno
  • 88
  • 5
  • Which E:E Which D? can you please elaborate? – noway to interrupt Nov 05 '22 at 12:48
  • E:E is the return array, so it should be the column where the credit card number is. D:D is the lookup array, so it must be the column where "TPXX" is located. B3 is the lookup value, which corresponds to one of the cells you want on the first sheet. – Bruno Nov 06 '22 at 23:33