INDEX MATCH combination can lookup left or right with a vertical arrangement of data or with horizontal data, UP or DOWN.
VLOOKUP can only return from left to right for vertical data and HLOOKUP from UP to down for horizontal data.
INDEX MATCH combination can lookup left or right with a vertical arrangement of data or with horizontal data, UP or DOWN.
VLOOKUP can only return from left to right for vertical data and HLOOKUP from UP to down for horizontal data.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks