Match, index, vlookup???????

[rogrand]

Hello to all,

Hope I can explain it. As an example, I have a workbook that contains two sheets. Sheet A and Sheet B

Sheet A contains to columns. One is is empty with information needed and other has a very large columns with names.

Sheet B contains helper list of itesm I want.

I need a formula that will fill in the empty column in sheet A with matches using the Sheet B items. If it does not match its ok if it has error or NA.

Hope I explained it so you the experts know.

In going over many youtubs I can summarized the following of function I tried to learn and implement.
Vlookup needs to have the items in the same worksheet and index and match only provides position

[hrlngrv]

Unclear. Your workbook doesn't clarify what you want. Yes, SheetA column A is empty except for a label in cell A1, column C contains a lot of strings down to row 25054. You want a formula for A2:A25054 which would provide the region IDs. However, SheetB contains only 3 entries in A1:A3, which appear to match entries in SheetA!C2:C25054, but there's nothing else in SheetB, certainly nothing labeled or looking like region IDs. If the region ID in SheetA would just be the row index for entries in SheetB!A1:A3, you could use

SheetA!A2: =MATCH(C2,'Sheet B'!$A$1:$A$3,0)

and fill that down into SheetA!A3:A25054. Most of those formulas would return #N/A because there's so little in SheetB.

[rogrand]

Hi. Yes i used that formula but it gives a position result and I am needing the actual name it matched.
Need it to return a value not a number and since vlookup values are on another cell this will not work. Match returns a number.


I am trying to clean routine report with only specific names to be display so I can remove all other. I my report I have helper cells of those items.

[hrlngrv]

You want text rather than a number. Understood. However, you've provided NO INFORMATION about where the text you want returned might be. Would there be a second column in SheetB which gives the text you want returned? If so, and if that 2nd column were column B in SheetB, try

'Sheet A'!A2: =VLOOKUP(C2,'Sheet B'!$A$1:$B$3,2,0)

If that's not sufficient, YOU need to provide more information.

[rogrand]

Ok.. Thank you for your patient. Let me rephrase. I did more research and it looks like its going to be a index / match that I am not able to make it work. Added a spreadsheet with three column with the expected outcome in Column A. Hope this helps you help me..... Thank you again for taking the time.

[rogrand]

I got it !!!!!!! Needed to enter the f4 key with the following:

=INDEX($E$2:$E$3,MATCH(C$2:C17,$E$2:$E$30,0))

Gain, thank you.

[FDibbins]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[FDibbins]

The problem with the formula .............

Administrative Note:

Welcome to the forum.

Sorry, but your post does not comply with Rule #6 of our Forum RULES:

Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.

If you are unclear about the request or instruction, then send a private message to them asking for clarification.

All Participants:

Please do not post a reply in a thread where a Moderator or Administrator has requested an action that has not yet been complied with (e.g. title change, code tags requested, etc.). Thanks.