I have table1 (id, assetid) and table2 (id, assetid, lat)
In table1 I want to create a new column which does the following:
Looks for matching ‘assetid’ (matching table1 and table2) and then returns (from table 2) the ‘lat’ number.
I ended up with the following however this isn’t right
=IF((COUNTIF(table2!,)<0),,"")
>Solution :
Try INDEX()/MATCH().
=INDEX($G$2:$G$4,MATCH(B2,$F$2:$F$4,0))
Below formulas should also work.
=VLOOKUP(B2,$F$2:$G$4,2,FALSE)
=XLOOKUP(B2,$F$2:$F$4,$G$2:$G$4,"")
=@FILTER($G$2:$G$4,$F$2:$F$4=B2)
