I have 2 tabs.
Tab 1 has 5 column headers - price ,stock ,stock ,price ,stock
tab 2 has price. Now I want to return 4 in front of price as in tab 1, last price has column number 4
So, I tried using match function but it gave me 1 instead of 4 as it gave me the first price location and not the last.
Please help
Bookmarks