Reading Info

**Injury Finger** · 03-18-2010, 06:02 AM

Hello

First can i say that this forum is great and has helped me a lot.

My problem:

I work in purchasing and one of my tasks is to find out which parts i need each week.

The current way of doing this is to get the parent number (from a spreadsheet), and look individually from the system to get the parts inside and find the supplier. Its the latter which I need to sort out (Finding the supplier).

At my old employer we read this information from the system but here is a lot more strict and wont allow us access.

Is there a way to enter the part number into a column and it automatically pick up the supplier? Would i need a master list of all parts and suppliers for this?

any help would be great (or if you need me to explain better)

**teylyn** · 03-18-2010, 06:14 AM

Would i need a master list of all parts and suppliers for this?

Yes. After that it's a simple Vlookup or Index/Match, depending on your data structure.

**Injury Finger** · 03-18-2010, 10:52 AM

Thank you

i thought that may be the case

i have now exported all the info into tab 2. Is there a vlookup tutorial or anythin anywhere?

**shg** · 03-18-2010, 12:32 PM

See http://office.microsoft.com/en-us/ex...093351033.aspx

**Injury Finger** · 03-19-2010, 07:46 AM

Thanks

I havent used excel for approx 2 years so I am rusty to say the least.

I am trying to get the value to "" when an error has occured (IE: there is nothing to read)

What is the problem with?

IF(ISERROR($B2,FPL!$A$2:$Z$9999,8,FALSE),"",$B2,FPL!$A$2:$Z$9999,8,FALSE)

**martindwilson** · 03-19-2010, 08:04 AM

you have missed out the vlookup part
IF(ISERROR(vlookup($B2,FPL!$A$2:$Z$9999,8,FALSE)),"",vlookup($B2,FPL!$A$2:$Z$9999,8,FALSE))

**Injury Finger** · 03-19-2010, 10:18 AM

^ sorry

I have formulas running around my head

Surely a simple tab change should be the same. I get an error ' inconsistent formula' for teh following:

=IF(ISERROR(VLOOKUP($B2,Data!$A$1:$AK$55555,2,FALSE)),"",VLOOKUP($B2,Data!$A$1:$AK$55555,2,FALSE))

Its not the ISerror as it doesnt work without it neither!

The only difference is the tab from 'FPL! to Data! & the column numbers.

This one is literally driving me nuts because i can see no reason for it not to work

**martindwilson** · 03-19-2010, 06:36 PM

=IF(ISERROR(VLOOKUP($B2,data!$A$1:$AK$55555,2,FALSE)),"",VLOOKUP($B2,data!$A$1:$AK$55555,2,FALSE)) works fine for me

**teylyn** · 03-19-2010, 11:06 PM

I get an error ' inconsistent formula' for teh following:

this is just a warning from Excel that the formula is not the same as in the surrounding cells. As long as you get the expected result in the cell, ignore the warning.

**martindwilson** · 03-20-2010, 07:20 AM

ah ive turned of error checking on my 2003! so to get rid of that message you can :-On the Tools menu, click Options, and then click the Error Checking tab.
Select or clear the check box for the options you want