Hi,
I need to get the value high lighted in yellow in attachment based on row value i.e 'mumbai' and column value i.e 'col3'. I can use vlookup but in my case i have 100 columns are there so i can't count index number. so please give me any formula to search based on row value and column value combined.Test123.xlsx
Bookmarks