Suppose your list of data above is in cells A1 to B7 in the same sheet. Then you can use this formula in cell J14:
=VLOOKUP(F14,$A$1:$B$7,2,0)
Hope this helps.
Pete
Suppose your list of data above is in cells A1 to B7 in the same sheet. Then you can use this formula in cell J14:
=VLOOKUP(F14,$A$1:$B$7,2,0)
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks