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
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