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

##### New Member
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,

### Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

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.

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,

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?

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))

Replies
3
Views
449
Replies
0
Views
389
Replies
1
Views
360
Replies
1
Views
366
Replies
11
Views
413

1,196,269
Messages
6,014,346
Members
441,816
Latest member
Klingon1960

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back