SOLVED

# A easy one for you pros out there - Fill cell in a row based on similar value in two tables

Copper Contributor

# A easy one for you pros out there - Fill cell in a row based on similar value in two tables

I have a spreadsheet with two tabs.

One tab is the data tab which is filled with 7 columns and a few thousands rows.

The other tab contains reference data where I want to get the data to fill in the first tab.

2 Replies

# Re: A easy one for you pros out there - Fill cell in a row based on similar value in two tables

we can use vlookup to get matching values from tab2
best response confirmed by BkkBound (Copper Contributor)
Solution

# Re: A easy one for you pros out there - Fill cell in a row based on similar value in two tables

XLOOKUP (I don't know your sheet name, so I used "Tab2"):

``=XLOOKUP([@Itemnumber],'Tab2'!\$A\$2:\$A\$600,'Tab2'!\$C\$2:\$C\$600)``

1 best response

Accepted Solutions
best response confirmed by BkkBound (Copper Contributor)
Solution

# Re: A easy one for you pros out there - Fill cell in a row based on similar value in two tables

XLOOKUP (I don't know your sheet name, so I used "Tab2"):

``=XLOOKUP([@Itemnumber],'Tab2'!\$A\$2:\$A\$600,'Tab2'!\$C\$2:\$C\$600)``