Forum Discussion
Solved
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.
XLOOKUP (I don't know your sheet name, so I used "Tab2"):
=XLOOKUP([@Itemnumber],'Tab2'!$A$2:$A$600,'Tab2'!$C$2:$C$600)
2 Replies
XLOOKUP (I don't know your sheet name, so I used "Tab2"):
=XLOOKUP([@Itemnumber],'Tab2'!$A$2:$A$600,'Tab2'!$C$2:$C$600)- we can use vlookup to get matching values from tab2
