I need to create a formula that pulls a matching value from a range on another worksheet

[adamacme]

Hi this is my first post here, maybe its as easy as a VLookup or some Variation of a MATCH Formula, but basically what I am trying to do is make it so that if the value of a certain cell matches a value located in a separate sheet of the same workbook, then the value in the cell to the right of the matching cell of the range is displayed in a blank cell on the first sheet. Any ideas? I can't post attachments as I haven't earned enough posting points yet I guess, but if you need a more detailed example of what I'm talking about I can try to type out a mock worksheet. Thanks,

 

[Fishboy]

Hi Adamacme,

Your best best is to google Mr Excel HTML Maker. This will let you copy and paste an example of your data directly into the forums so people can try and help you further.

 

[adamacme]

Hi Adamacme,

Your best best is to google Mr Excel HTML Maker. This will let you copy and paste an example of your data directly into the forums so people can try and help you further.

Thank you for the tip Fishboy I will look into it and add the example directly into the thread. Thanks,

 

[adamacme]

I wasn't able to get the HTML Maker to work on my computer, so I will just do my best to explain my issue without it. Right now I am able to get it to work using a VLOOKUP, but the range I need to make it work is A2:AD81, and there is a chance that there are multiple cells in the range that have an exact match to the value I am looking up (i.e., $1,950). When it looks up i am having it display the value 16 cells over from the match. EXAMPLE: If the cell reading $1,950 is in A15, then it displays the value in cell O15. The issue I am running into is that if cell H12 also says $1,950 I don't want it to display the value of AA12. Is there a better formula than VLOOKUP to act as a sort of fail safe from this happening?

 

[adamacme]

I figured it out. In case anyone else is looking for a similar solution, what i did was an INDEX MATCH MATCH. I took the value of the vertical array, and matched it with the horizontal array, cross pointing the specific value I wanted. My formula is =INDEX(Sheet1!A1:AD81, MATCH(B4, Sheet1!A1:A81, 0), MATCH(R24,Sheet1!A1:AD1,0))