# Lookup on variable entries

#### jasonbridge

##### New Member
Hi,

I am trying to get a value based on the following:

I have a table that has 5 columns each with a different heading (system type), then after these comes another 3 columns that gives user details. In the first 5 columns there is a user ID in each cell e.g.

LRSMS MRSMS RRSMS GRSMS WRSMS Name Manager Location
12345 56789 54878 12989 68595 John Sally London
56789 59800 12989 55555 68790 Tim Sally London

Then I have another worksheet that has one column where the cell has one of the 5 SMS codes and then in the next column has the user ID. What I need to do is do a sort of lookup that first recognises the system type and then looks up in the corresponding column for the matching user ID. e.g. If the system is LRSMS and the ID is 56789 then it returns Tim as the user.

Hope this makes sense, can anyone help?

Cheers
Jason

### Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
Try:

=INDEX(Sheet1!F1:F3,MATCH(A2,INDEX(Sheet1!A1:E3,0,MATCH(A1,Sheet1!A1:E1,FALSE)),FALSE))

where A1 contains LRSMS and A2 contains 56789.

Bingo! Thanks for that it is greatly appreciated

Replies
3
Views
330
Replies
0
Views
439
Replies
0
Views
1K
Replies
1
Views
317
Replies
0
Views
2K

1,220,011
Messages
6,151,449
Members
451,028
Latest member
greekness1

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