Try this in L7 and drag across and down:
=VLOOKUP($K7,$A$7:$C$11,COLUMNS($K$7:L7),FALSE)
Try this in L7 and drag across and down:
=VLOOKUP($K7,$A$7:$C$11,COLUMNS($K$7:L7),FALSE)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks