Locating a value in a range from a reference.

M

mr_chattaway

Afternoon,

I'm looking at trying to find a value on a worksheet using a text string but
cannot seem to get any formula to work (I cannot use VB on any sheets).

A brief example of what I am trying to do:

"Sheet 1"

A B C
Bob ? ? ?
John ? ? ?
Sue ? ? ?

?=the formula

This searches sheet 2

"Sheet 2"
8 9 10 11
John a
Bob a
Sue c


What should happen is that on sheet 1 it will find where 'a' is and the ?
will change to 9 for John (8 for bob, etc)

I have tried to use INDEX,MATCH,LOOKUP,LOOKDOWN,LOOKSLIGHTLYBEMUSED and I
can't seem to build a combination that works.

Hope someone can help, if it's not possible no worries (I can then show the
powers-that-be that it can't be done so they can stop asking for it.)

Thanks in advance for any help.

Matt
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HLOOKUP, LOOKUP & MATCH doesn't work. Seems not right. 1
Match and delete rows on two different sheets from reference numbers 4
Finding the right style field in VBA 0
trouble with (complicated) vlookup searching another workbook 2
Using a vlookup to search multiple criteria for one result? 7
Finding the proper style field and the numbered paragraph value within the style 0
comparing sheet to sheet and adding value 1
Searching the formula (not the value) for a text string 1

Top