Not sure if I'm wording this correct but basically what I'm trying to accomplish is:
Source:
I'm trying to find a formula that would allow me to LOOKUP value in COLUMN1 (COL1 above) and then return the values in COLUMN2 (COL2 above). So in the above example Lookup ABC, returns 1, 32, 23, 14 (but in the same layout as above, vertically).
Please Login or Register to view this content.
Sure I'm missing something simple here. Thanks in advance.
Index() Using Match to find ABC then use increments of +1 to return the numbers next to it.
If someone helped give them rep using the star button.
If you have received a satisfactory solution please mark the thread solved. If not Fotis will come for you at night :P
Thank you. Not sure why it didn't click to use Index/Match. Worked perfectly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks