Find first occurrence of each value in a table.

Hello ,

Just wondering how you would find the first occurrence of a value in a table and then copy that value and then whatever is in column g of that row

Thanks in advance!

Kind regards,

T

You can use VLOOKUP if the lookup_value is in a column to the left of column G in the table, or you can use an INDEX/MATCH combination if column G is to the left of the lookup_column.

If you want a more specific answer then you need to provide more details of how your data is laid out.

Hope this helps.

Pete

hello,

I have data in columns E-Y I want to search columns E-T for first occurrences of batchcodes (2 letter combinations) and return the occurrence and the value in the the same row but column V

I currently have this

Please Login or Register  to view this content.

but it is coming up with a type mismatch for I and J

what do I do?

Kind regards,

T