Using vlookup with the IF function

CSzoke · #1 03-25-2012, 02:41 PM

Think I will definitely go with the hidden columns.

WOW. Thank you very much this was EXACTLY what I was trying to do.

I will add the list for the part numbers and the equipment I think. The example I attached was just of 2 part numbers and just some basic operations. There is another workbook where I can pull data from to expand what I started with. The company has hundreds of parts numbers and hundreds of processes. And, now that you have shown me how to do this, there are a few other workbooks I have in mind where i can simplify the way we store as well as analyze our data.

excelledsoftware · #2 03-25-2012, 03:06 PM

Quote:

Originally Posted by CSzoke

Think I will definitely go with the hidden columns.

WOW. Thank you very much this was EXACTLY what I was trying to do.

I will add the list for the part numbers and the equipment I think. The example I attached was just of 2 part numbers and just some basic operations. There is another workbook where I can pull data from to expand what I started with. The company has hundreds of parts numbers and hundreds of processes. And, now that you have shown me how to do this, there are a few other workbooks I have in mind where i can simplify the way we store as well as analyze our data.

Very glad to help. Feel free to mark as solved

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using Vlookup & IF together	thelauncher	Excel	5	08-25-2013 11:32 PM
Vlookup	Karen615	Excel	4	09-12-2011 02:30 PM
Using IF & VLOOKUP together	junction	Excel	7	11-18-2010 05:15 AM
Help with VLOOKUP	sakhtar	Excel	2	07-24-2010 07:39 PM
Is this possible using the Vlookup or any other function?	Delson	Excel	4	02-08-2010 01:27 PM