Helo,
I am looking for help on how to create the proper Vlookup formula to populate a column with values based from a table.
See attached file.
I would like to match the values in column A with the table, to populate column B. So for example, B2 would be 'Internal', B3 would be 'External' etc. For blank values, such as in A11, I would like to see B11 blank as well.
If anyone could help me with the proper formula, I would appreciate it.
Thanks,
Nathan
Last edited by nmss18; 11-14-2011 at 03:19 PM. Reason: solved
try:
=IF(A2="","",VLOOKUP(A2,$G$2:$H$16,2,0))
copied down
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Brilliant. It works. Thanks much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks