Hello all,
Needing to figure out how to grab owner information (Name in this example) based on a specific identifier in a table. Please see my attached file for example.
In the FeedData sheet, I need to populate the owner column with the right owner name that pertains to the lot (Column A). The reference table is in the <Lot Owners> tab within the spreadsheet. Note that I need to return "Other" if no lot owner is listed in the <Lot Owners> table.
Thanks ahead for your time.
-Manny
Basic VLOOKUP:
=VLOOKUP([@Lot],TblLotOwners[#All],2,0)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thanks. That works. The only problem is I need the formula to return the text "Other" if the value is a Zero. How best to accomplish that?
-Manny
This:
=IF(formula=0,"Other",formula)
Perfect. That works.
Thanks
-Manny
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks