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:
[TABLE="width: 500"]
<tbody>[TR]
[TD]URN[/TD]
[TD]Ref[/TD]
[/TR]
[TR]
[TD]2318[/TD]
[TD]YOU008[/TD]
[/TR]
[TR]
[TD]2319[/TD]
[TD]YOU009[/TD]
[/TR]
</tbody>[/TABLE]

tab 2:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Ref[/TD]
[TD]sALES[/TD]
[/TR]
[TR]
[TD]YOU008[/TD]
[TD]£5[/TD]
[/TR]
[TR]
[TD]YOU008[/TD]
[TD]£10[/TD]
[/TR]
[TR]
[TD]YOU009[/TD]
[TD]£5[/TD]
[/TR]
[TR]
[TD]YOU009[/TD]
[TD]£25[/TD]
[/TR]
[TR]
[TD]YOU009[/TD]
[TD]£23[/TD]
[/TR]
[TR]
[TD]YOU009[/TD]
[TD]£15[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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[TABLE="class: grid, width: 300"]
<tbody>[TR="bgcolor: #DAE7F5"]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD]tab 1:[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD]URN[/TD]
[TD]Ref[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: right"]2318[/TD]
[TD]YOU008[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: right"]2319[/TD]
[TD]YOU009[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD]tab 2:[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD]Ref[/TD]
[TD]sALES[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD]YOU008[/TD]
[TD]£5[/TD]
[TD="align: right"]2318[/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD]YOU008[/TD]
[TD]£10[/TD]
[TD="align: right"]2318[/TD]
[/TR]
[TR]
[TD="align: center"]11[/TD]
[TD]YOU009[/TD]
[TD]£5[/TD]
[TD="align: right"]2319[/TD]
[/TR]
[TR]
[TD="align: center"]12[/TD]
[TD]YOU009[/TD]
[TD]£25[/TD]
[TD="align: right"]2319[/TD]
[/TR]
[TR]
[TD="align: center"]13[/TD]
[TD]YOU009[/TD]
[TD]£23[/TD]
[TD="align: right"]2319[/TD]
[/TR]
[TR]
[TD="align: center"]14[/TD]
[TD]YOU009[/TD]
[TD]£15[/TD]
[TD="align: right"]2319[/TD]
[/TR]
</tbody>[/TABLE]

tab 1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR="bgcolor: #DAE7F5"]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH="bgcolor: #DAE7F5"]C9[/TH]
[TD="align: left"]=INDEX('tab 1'!$A$3:$A$4,MATCH(A9,'tab 1'!$B$3:$B$4,0))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[SUMU15]

Yay! that works.
thank you.