Finding Formula?

M

M P

I need to create a formula that will set a value from a table. For example,
I have these data on Sheet 1:

ID Name
01 Mark Anthony
02 Test Sample
03 Example Test
04 Beta VHS

On Sheet 2, I have the same table but I need to type only the name on one
column and the ID is automatically indicated on the same row. I have tried
the Lookup function but I can't make this run. Please help.

Mark
 
R

Ragdyer

Vlookup wouldn't work in this situation since the actual lookup column is
not on the left.
Lookup would work, but that can't be configured to *insure* an exact match.

The way to go would be to use Index and Match.

With "ID" in column A, and "Name" in column B of Sheet1,
And with you typing in the name on Sheet2 in column C, enter this formula in
D2 of Sheet2:

=INDEX(Sheet1!A2:A5,MATCH(C2,Sheet1!B2:B5,0))
 
M

M P

great! thanks...


Ragdyer said:
Vlookup wouldn't work in this situation since the actual lookup column is
not on the left.
Lookup would work, but that can't be configured to *insure* an exact match.

The way to go would be to use Index and Match.

With "ID" in column A, and "Name" in column B of Sheet1,
And with you typing in the name on Sheet2 in column C, enter this formula in
D2 of Sheet2:

=INDEX(Sheet1!A2:A5,MATCH(C2,Sheet1!B2:B5,0))
--
HTH,

RD

-------------------------------------------------------------------------- -
Please keep all correspondence within the NewsGroup, so all may benefit !
-------------------------------------------------------------------------- -
Click to expand...
 
Top