Hi guys
Please can someone help me complyete my index match formula to return a barcode from another tab based on a value?
mY FIRST tab (tab 1) n cell G6 I am trying to write:
=INDEX($A$6:$A$54,MATCH(A6,'TAB2'!$D$16:$D$5000)) and I want to say if A6 in 16:D5000 on tab 2, return the value from column K on TAB 2.
hOw do I add this please?
Thank you!
Bookmarks