Forum Discussion
Excel formula
Hello all, Could someone please help me I have 2 data tabs of 000s of horizontal data fields and probably 30 columns each tab first tab is a carrier shipping, the other dispatched tab, the common ...
=HLOOKUP(VLOOKUP(A5,A7:B21,2,FALSE),D2:R3,2,FALSE)Maybe with HLOOKUP and VLOOKUP. An alternative could be INDEX and MATCH.