Automate Vlookup in Excel spreadsheet
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
February 25th, 2015 5:33pm

Hi,

Try the following by placing the VLOOKUP in cell A1 (colA)

=VLOOKUP(B1, SHEET2!A1:B5, 2, FALSE)

Explanation:

In cell A1 you place the VLOOKUP function. After the bracket you click on the cell that will contain the value to look for (in your case ColB). Next you select the range where to look, in your case sheet2 A1:B5. You can just select this using the mouse.

Next enter the column which contains the return value. In your case column 2.

Finally the last argument you need to type or click  FALSE. This will result in a specific result.

So the above formula will return "Damaged" if the user types in a 1 in the first sheet in cell B1.

Maurice

Free Windows Admin Tool Kit Click here and download it now
February 26th, 2015 2:57am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics