LinkBack URL
About LinkBacks
Using the attached Excel file, how do I lookup the State Name (State worksheet) using the State Code (Counties worksheet) and display the State Name in column C (Counties worksheet)?
Jim
Using the attached Excel file, how do I lookup the State Name (State worksheet) using the State Code (Counties worksheet) and display the State Name in column C (Counties worksheet)?
Jim
Jim15
Try
=VLOOKUP(B2,STATE!A:B,2,0)
Martin
You have a mixture of text values and numeric values in your lookup table, so put this in C2:
=VLOOKUP(IF(B2*1<10,B2,B2*1),STATE!A:B,2,0)
then copy down.
Hope this helps.
Pete
Thanks to both of you for the quick reply! I decided to use Pete's suggestion and it works like expected.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks