Vlookup and If statement

Hello,

my name is katie and this is my first post.

I have tried and failed miserably to get a formula which will look up data based on two different crtierias and if both matched return the relevant value.

The data that I want to return is organised as per the below:

entity code value



5B 0121983 30,134.47
5B 0121936 97,804.38
5A 0121983 48,611.77
5A 0121934 217.68
5A 0121933 11,429.07
5A 0121932 16,239.06
5A 0121925 68,607.58
5A 0121928 18,446.06
5A 0121929 3,003.78


And I am trying to return it to the below table:

codes 5A 5B
0121983 x
0121936
0121935
0121934
0121933
0121932


Therefore I would like a formula which would look for Entity 5A in table 1 and then look for the codes in Table 2 and if both matched return the relevant data from table 1. So for 'x' in table 2 this would be 48,611.77.

Any ideas?

many thanks
Katie

Hi, welcome to the forum!

use below formula

=(TRIM(MID(A10,4,7)))

------------------------------------------------------------------------------------------
CLICK the STAR icon on the left side below their user name to say thank you to those who had helped you. Thanks.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.

Hi, welcome to the forum!

use below formula

=(TRIM(MID(A10,4,7)))

------------------------------------------------------------------------------------------
CLICK the STAR icon on the left side below their user name to say thank you to those who had helped you. Thanks.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.

thanks guys for your help: used martindwilson soln and thisdid the trick,

thanks!