Lookup for once

  • Thread starter Thread starter Kevin Lin
  • Start date Start date
K

Kevin Lin

Hi All,

Need help on the following.

A V
1 AAA001 AAA001
2 AAA001 BBB001
3 AAA001 BBB002
4 BBB001
5 BBB001
6 BBB002

I need a formula in column V that could auto pick-up or
lookup what was inputed in column A and without repeating
in column V.

Thank you,
Kevin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula guru needed 5
Scrabble Value calculation for Welsh words 0
Need V-Lookup to Return A Row, Not Just Single Value 2
Sorting and Formulas 1
V Lookup Not working since change 3
Need Major Help on the Macro 12
2nd and 3rd last number in a column - how to get it? 4
lookup using row & column heading. 6

Back
Top