Relation of 2 Tables

Hello,

I have 2 tables (Table 1 and Table 2) and I need to fill Item 3 of the Table 2 with the values of the Table 1. I could easily use the function Vlookup but how it works for the items not colored? It gives #N/A! (see attachment)

Thanks!

A simple fill-in-from-above formula set-up should do it for you
Assuming you've got the vlookup formulae in K3 down, with all the #N/As
Put in L3: =K3
Put in L4: =IF(ISNA(K4),L3,K4)
Copy L4 down
---------------------------------------
Success? Wave it, click on the little star at the bottom left of my responses

Thank you for your answer!
What I need is a formula that fills the Item 3 of the Table 2 that is related with Table 1. For Item 1 = a and Item 2 = 1 I should have on Item 3 of Table 2 the value 123. The problem is for Item 2 between 2 and 5 that value should be the same (123) and should change for 456 for Item 3 = 6. It's a bit confuse but try to fil the column "K" with the values from the Table 1.

Thanks!

For Jacc:
I think that's it! I will try this formula in my work and then I will tell if it works.
Thank you very much!!

The formula works but the Table 1 should be sort by Item 2. Otherwise the formula doesn't work well.

Thank you very much for your attention!
In that example it works fine. I've got a larger table where i will test with that formula. I think it will work.