i have data in a1:a100, b1:b100, c1:100
if c1 data mach between b1:b100 in any cell then paste result front that cell (from a1:a100)
example
if c1 data mach in b5 then paste a5
if c10 data mach in b20 then paste a20
i have data in a1:a100, b1:b100, c1:100
if c1 data mach between b1:b100 in any cell then paste result front that cell (from a1:a100)
example
if c1 data mach in b5 then paste a5
if c10 data mach in b20 then paste a20
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks