Forum Discussion
Pinning data???
Hi there,
I have one group of data that has over 2000 rows and another set of 512 that need to be attached to their appropriate ID in one column. How do I do this?
1 Reply
You can use VLOOKUP, INDEX/MATCH or XLOOKUP.
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft Support
=IFERROR(INDEX(J$2:J$13,MATCH($A2,$I$2:$I$13,0)),"")For example this formula attaches the data from columns Info4 and Info5 to the table on the left.
