Excel Question

  dazwm 12:26 26 Sep 06

I have a report to do:-

Column A - Date
Column B - Description
Column C - Agent Number
Column D - Quantity

What I need to do is change the agent number to a name i.e 9 is Darren, 10 is Lee etc there may be a 1000 rows so is there a formula that will find all the 9's and change them to Darren for me? Thanks.

  VoG II 12:29 26 Sep 06

You need to make a table with numbers on the left, names on the right. Say this goes in Sheet2!A1:B10.

To lookup value 9 and return Darren

=VLOOKUP(9, Sheet1!A1:B10, 2, FALSE)

or you can nreplace the 9 with a cell reference e.g. C11.

  VoG II 12:29 26 Sep 06

=VLOOKUP(9, Sheet2!A1:B10, 2, FALSE)

  VoG II 12:59 26 Sep 06

Or better if you are going to copy the formula down from say E2

=VLOOKUP(C2, Sheet2!$A$1:$B$10, 2, FALSE)

This thread is now locked and can not be replied to.

Surface Pro 5 News - release date, UK price, features, specs

Animator Emanuele Kabu’s psychedelic video is a stunning tribute to Lisbon city

Best Mac antivirus 2017