Excel 2007 : IF function

Your post and question are still not clear.

Your request:

HTML Code: 

E2 on List2 is Material and there is nbo matching column on sheet1.
There is no "row A". Did you mean column A?.
You want to compare five values from List2 with what five values/text on list1?

Give a specific example with result. Enter the expected result manually and describe the logic to get that result.

I am sure it's clear in your mind, what you want, but we can't read your mind, so you need to help us understand.

modytrane.

oldchippy you all most have it, its the oposit of this, im not looking for those 4 values to be VLOOKUP im looking for the colum $Šifra$ to be VLOOKUP under those 4 values
I tryed this:

=VLOOKUP(E5:H5;Tabela5[[Šifra]:[Dim.(mm)]];1;FALSE)

OK,
Here's a sort of crude solution, but it's simle and it works.
See the atccahed file.
On List1, I've created a column A and on List2 I added column R.
You can hide both of these columns.
Now look at the formula in C21 on List2 sheet.
You can drag that formula up and down that column.
Also, drag formula in col. A[List1] and R[List2].
Hope it works for you.

You can try it out by entering different values in E21 thru' H21 on List2 and see C21 give you the right answer.
modytrane.

Ok so it is posible and works so tnx.
I'm still trying to make something witouth help cells hehe. but ill use this now
It realy helps a lot ty.