PDA

View Full Version : Automate Vlookup in Excel spreadsheet



MacroUser
02-25-2015, 03:24 PM
Hello All,

I'm kinda stuck with this spreadsheet lookup. I've a sheet 1 and sheet 2 in single spreadsheet:
Sheet 1..........................Sheet 2



Col A
Col B
Col A
Col B




1
Damaged




2
Rework Needed




12
Customer Reject




11
Lost




16
Poor Quality


I need to automate this using Vlookup/or any other technique you guys suggest, so that when user enters value say (1 or 2) in Col B of sheet 1 then Col A of (sheet 1) will populate the values automatically from sheet 2 (Damaged, Rework needed, etc)

Please help guys

Paul_Hossler
02-25-2015, 06:29 PM
So if someone enters a 16 in A1 of Sheet1 you want "Poor Quality" in B1?

Why not just use a normal worksheet VLookup formula in B1?

Bob Phillips
02-26-2015, 02:56 AM
So if someone enters a 16 in A1 of Sheet1 you want "Poor Quality" in B1?

Other way around Paul.

=VLOOKUP(B1,Sheet2!A:B,2,False)

in A1 and copy down.

Paul_Hossler
02-26-2015, 01:11 PM
A - B

B - A

Close enough for government work :*)