what is the formula for something like this:
='sheet1'!H & current sheet('sheet2'!) A2 (A2 contains row number as number)
column a contain text: Apple, Bannana, Coconut, Apricot...
column b contains buy price....
column c contains sell price...
column d contain stock..
after i find row number using =MATCH(A2, 'sheet1'!A1:A3456,0)
how proceed to get value of sheet 1 column b by using row number what i just find earlier
Solved by G. H. in 18 mins