IF Statement and Vlookup help

[Fish10800]

I have this document that myself and another employee use. The ID section is where I need help (column F&G the Blade Sizes) the if statement being used is broken into two lines. When you enter the letters A-I you get the blade size on the first line. When you enter J-S you get the rest of the blade sizes.

This is all fine but I would like to make everything one line for sorting purposes. I was wondering if this is possible with Vlookup or something else? I am not sure how to combine the formulas that are on two lines now into one line. I will still need it to function the same way. When ever I enter the letters A through S I still need the blade size to pop up but only on one line instead of two.

I hope this all making sense, I have attached a copy of the sheet to help clear things up.

Thank youBANDSAW BLADE ANALYSIS REPORT (BLANK) (D4.439).xls

[tigeravatar]

Fish10800,

Attached is a modified version of your workbook. I added a worksheet (which is hidden) that contains a table of ID's and their respective Blade Sizes. I named the table BladeTable. Then I replaced the formula you had with this one:
=IF(F9="","",VLOOKUP(F9,BladeTable,2,FALSE))

[Fish10800]

Thats what I was looking for 100% thank you I appreciate it. I knew it involved vlookup but I am not sure how to use that function very well.

Can you do the same thing you just did for this file also, This is the summary that uses the same format. You don't have to hide the worksheet though. I will most likely unhide it.

BANDSAW BLADE SUMMARY ANALYSIS REPORT - 2012 (Blank).xls

[tigeravatar]

Here you go. Learn from how this is done and if you have any more, use what's been provided here as an example