Hi everyone,
I have a table similar to the following one, but contains thousands of rows.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Country[/TD]
[TD]ID[/TD]
[/TR]
[TR]
[TD]Brazil[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Belgium[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Russia[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Russia[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]Belgium[/TD]
[TD]300[/TD]
[/TR]
[TR]
[TD]Brazil[/TD]
[TD]200[/TD]
[/TR]
</tbody>[/TABLE]
Each cell in column A has a Sale ID in Column B, but some of them are empty (in column B). I would need a formula in B1 that vlookup value in column A, returning column B value.
I tried the following:
=VLOOKUP(A2,A:B,2,0)
=VLOOKUP(A:A,A:B,2,0)
and some more, but it gives me error.
The aim of this formula is that I want to fill the first part of column B.
Any help?
Thanks
I have a table similar to the following one, but contains thousands of rows.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Country[/TD]
[TD]ID[/TD]
[/TR]
[TR]
[TD]Brazil[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Belgium[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Russia[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Russia[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]Belgium[/TD]
[TD]300[/TD]
[/TR]
[TR]
[TD]Brazil[/TD]
[TD]200[/TD]
[/TR]
</tbody>[/TABLE]
Each cell in column A has a Sale ID in Column B, but some of them are empty (in column B). I would need a formula in B1 that vlookup value in column A, returning column B value.
I tried the following:
=VLOOKUP(A2,A:B,2,0)
=VLOOKUP(A:A,A:B,2,0)
and some more, but it gives me error.
The aim of this formula is that I want to fill the first part of column B.
Any help?
Thanks