Using IF and VLOOKUP?

[SUMU15]

So, I'm new to this forum and hoping you can help me with a formula... I think it's simple but explaining it might be hard.

I have two tabs:

tab 1:

URN	Ref
2318	YOU008
2319	YOU009

<tbody>
</tbody>

tab 2:

Ref	sALES
YOU008	£5
YOU008	£10
YOU009	£5
YOU009	£25
YOU009	£23
YOU009	£15

<tbody>
</tbody>

I want a formula that will assign the correct URN to the ref in tab 2 - for example YOU008 would be assigned URN 2318 and YOU009 would be assigned URN 2319

I think I need to do a VLOOKUP on tab 2 that will assign the URN value in tab 2. So a combination of an if command and a v-lookup.

Make sense to anyone out there?

Thank you!

 

[Weazel]

maybe something like...

Unknown

	A	B	C
1	tab 1:
2	URN	Ref
3	2318	YOU008
4	2319	YOU009
5
6
7	tab 2:
8	Ref	sALES
9	YOU008	£5	2318
10	YOU008	£10	2318
11	YOU009	£5	2319
12	YOU009	£25	2319
13	YOU009	£23	2319
14	YOU009	£15	2319

<tbody>
</tbody>

tab 1​

Worksheet Formulas Cell Formula C9 =INDEX('tab 1'!$A$3:$A$4,MATCH(A9,'tab 1'!$B$3:$B$4,0)) <tbody> </tbody>

<tbody>
</tbody>

 

[SUMU15]

Yay! that works.
thank you.