How do I auto tabulate the Column in B and C once I copy a Number that has been appeared before?

Asked Mar 21 '23 at 08:00

Active Mar 21 '23 at 08:00

Viewed 35 times

How do I auto tabulate the Column in B and C once I copy a Number that has been appeared previously?

=if(countif($A:$A,A6)>1, VLOOKUP(A6,$A:$B,2,False),"") I tried using this but not all the time it works. some fields cannot publish. I have aligned them to the same text format but does not help.

https://docs.google.com/spreadsheets/d/1p_uWN-CCeO1K16GkJKamSKKm1bUGOhFlVU3vlfHwxkY/edit?usp=sharing

Auto Tabulate when the same number is entered into the sheet.

asked Mar 21 '23 at 08:00

Ben Au

What do you mean by `Auto Tabulate`? Which one is your desired output? – Harun24hr Mar 21 '23 at 08:10
@Harun24hr My desire output is Column B and C. If a number is entered in column A and there is previous records, it will auto tabulate. If there no previous record, it will be empty. – Ben Au Mar 21 '23 at 10:16
How google-sheet will generate serial numbers? Or do you only want word `Auto Tabulate` to column B and C? – Harun24hr Mar 21 '23 at 10:20
can someone help on this? – Ben Au Mar 21 '23 at 12:55
Your question is not clear. How you will define text of column B and C? Any explanation? – Harun24hr Mar 22 '23 at 02:00

How do I auto tabulate the Column in B and C once I copy a Number that has been appeared before?

0 Answers0