I have a list in column A with corresponding values in column B. When I enter info (that matches choices in column A) in column F I want the corresponding value that is in column B to display in column G.
I have attached the attempted spread sheet.
Perhaps I need to use a different formula?
Any help would be appreciated!
Thank You,
Mike
Hi,
you're on the right track! In cell G5 use
=VLOOKUP(F5,$A$5:$B$37,2,FALSE)
and copy down.
note the last parameter, which ensures that only exact matches are returned. Also, note the $ signs in the lookup range, which ensure that you can copy the formula down.
cheers
In G2 copy this formula
=VLOOKUP(F5,$A$5:$B$37,2,0)
copy G2 down. simple way of doing it select G2
bring the cursor to the bottom right when cursor turns into + and click that + sign.
In the formula note the dollar signs so that reference range can remain the same. see the last argument 0 which means exact lookup is required.
read the excel help on vlookup
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks