Index? Indirect? Match?

So I'm def not a power EXCEL user, but I've done some work on it, but not anything involving multiple sheet interactions. What I'm trying to do is when I key an item number into col. E sheet 1, it will look for the matching item number in sheet 2 col. C and then return in sheet 1 col. G the value of sheet 2 col. B of the matching item. Hopefully my attempt at attaching sheet 1 was successful. I frankly have no idea how to execute the formula nor even what to search- I have been searching for the last couple of hours and not turned anything up. Any help is much appreciated.

Cheers,
CP

There is no data in Sheet2. If you have data in columns C and B as you describe, then you could have this formula in G2 of Sheet1:

=INDEX(Sheet2!B:B,MATCH(E2,Sheet2!C:C,0))

Hope this helps.

Pete

If the formula returns #N/A then that indicates there is no matching data in column C. You can avoid that error like this:

=IF(ISNA(MATCH(E2,Sheet2!C:C,0)),"",INDEX(Sheet2!B:B,MATCH(E2,Sheet2!C:C,0)))

or like this:

=IF(COUNTIF(Sheet2!C:C,E2)>0,INDEX(Sheet2!B:B,MATCH(E2,Sheet2!C:C,0)),"")

and you could put some error message between the quotes like "not found".

If it pops up that window asking for a file then the problem is probably the sheet names - they are not the same as those in your file. If sheet names have spaces in them then you must have apostrophes around the sheet names, like this:

=INDEX('Sheet 2'!B:B,MATCH(E2,'Sheet 2'!C:C,0))

Obviously you can apply this to the previous two formulae.

I am reluctant to give out an email address on such a public forum, so I hope this helps.

Pete

I totally understand- thanks again for your help!