Excel Question

  dazwm 12:26 26 Sep 06
Locked

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.

Nintendo Switch review: Hands on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Here's what should be coming to Adobe Project Felix in 2017

Apple AirPods review: Apple's beautiful new Bluetooth headphones bring true intelligence to…