Function to fill in missing values

  • Thread starter Thread starter Sombra
  • Start date Start date
S

Sombra

I have a table where some items have a value in a certain column and
some don’t. Is there a function (Vlookup?) I could use to get the
correct value also to the empty rows in the table? I know how to do
this using IF-function if I sort the items according to their ID, but I
would really appreciate it if someone knows a way to do this without
sorting.

Item-ID Value Desired result
1 100
2 200
2 200 200
3 300 300
1 100 100
1 100
3 300
4 400 400

Thanks,
-Sombra
 
Sombra

Assuming Item-ID in column A. Enter in Value column B2

=A2*100

Drag/copy down column B.

Gord Dibben Excel MVP
 
Wish it really were that simple!

But actually, the values I put there were just an example, and th
value cannot be calculated from Item-ID.

I try to explain this again:

I have a colum that contains the number of the item. One item can b
present several times. In the next colum, the item either has a valu
or the value is missing. Each item has only one possible value.

What I want is to find this value and copy it to those items with sam
ID where the value is missing. But I need a function to do this as m
table has about 9 000 rows. And preferably, I want to do this withou
sorting.

Is this possible?

-Sombr
 
Back
Top