Excel Question

  dazwm 12:26 26 Sep 2006

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 2006

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 2006

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

  VoG II 12:59 26 Sep 2006

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.

Elsewhere on IDG sites

The Evil Within 2 review-in-progress

InVision Studio takes on Adobe XD and Sketch

Camera tips to take better iPhone photos

Comment transformer un iPhone en borne Wi-Fi ?