Trying to search and fetch the next cell in an array within only one row of data in Google Spreadsheet. Vlookup and hlookup don't work cause it is getting the data from next column or next row instead of the current column or row.
e.g. [A][B][C][D][E] e.g. [B][F][A][C][E]
so that when I try to lookup [A] in row 1, it will return ; lookup [B] in row 1, it will return ;
and lookup [F] in row 2, it will return ;