Finding Formula?

  • Thread starter Thread starter M P
  • Start date Start date
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
 
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))
 
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...
 
Back
Top