I have a list of data with the Header (Type). Under Type, there are about 1000+ Tax, 300+ Custom, 2000+ Refund and 500+ of other desrciption (random).
I want to do a connection between another table.
With Header Type and Description. I wanted Tax and Custom to show as Tax, Refund as Refund and other descruption as Misc. How do i do for the Misc part?
One way I can think of doing this is to make a small table like
Item | Category
Tax | Tax
Custom | Tax
Refund | Refund
Then in a helper column reference this range in a VLOOKUP.
=IFERROR(VLOOKUP(A2,$A$2:$B$4,2,FALSE),"Misc")
Then you can use the helper column as a filter or to sort on.
This can also be done with nested if statements instead of a VLOOKUP and possibly just plain lookup. I like the flexibility VLOOKUP gives for "growth."
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks