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
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)
Col A Col B Col A Col B 1 Damaged 2 Rework Needed 12 Customer Reject 11 Lost 16 Poor Quality
Please help guys