VLOOKUP - Varying Positions and Values

**croeder** · 06-17-2013, 04:11 PM

I am looking to use VLookup to return a value that may be in a varying column position.

In the attached example, if 3913 as the criteria lookup, I want it to travel across that row, find the 2, and return the value in the column or cell next to 2 (in this case the value returned would be 7.

Note - both 3913 and 2 would be referenced in fixed cells that could be changed.

The position of the 2 would change on each row.

If the file didn't upload, please let me know.

Thank you for the help.

**GeneralDisarray** · 06-17-2013, 04:26 PM

See the attachment, this formula takes care of the example given. you will need to edit this to fit your ranges or upload a worksheet example with more details.

Look in cell G4 for this:

=INDEX($A$4:$D$7,MATCH($B$1,$A$4:$A$7,0),MATCH($C$1,INDEX($A$4:$D$7,MATCH($B$1,$A$4:$A$7,0),),0)+1)

See the attached file.

--EDIT--

NOTE: I assume the first column is set. The "2" can move around and still be located with the 'middle' Match function, but the column with 3913 needs to remain unchanged for my solution.

ALSO if you ever find the "2" is in the last column (so there is nothing to the right of it to return), this formula will error out..... again I can give more details and help with an actual example (workbook) not a picture

**croeder** · 06-24-2013, 12:37 PM

Thank you....that solved my issue, much appreciated.

**croeder** · 06-24-2013, 12:43 PM

How do I mark a post a solved?

**GeneralDisarray** · 06-26-2013, 06:16 PM

To mark your thread solved do the following:
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save