Simple but stumped

[butters7388]

OK I have what I believe to be a simple query but I am stumped.

Pretty much a beginner user so need some help

ok so on sheet 1 I have this table

[TABLE="width: 500"]
<tbody>[TR]
[TD]Column G[/TD]
[TD]Column N[/TD]
[/TR]
[TR]
[TD]Eff Code[/TD]
[TD]Eff[/TD]
[/TR]
[TR]
[TD]Multistorey Unit[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Commercial[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Retail[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Sheet 2 I have this table

[TABLE="width: 500"]
<tbody>[TR]
[TD]Column A[/TD]
[TD]Column B[/TD]
[/TR]
[TR]
[TD]Multistorey Unit[/TD]
[TD]75%[/TD]
[/TR]
[TR]
[TD]Commercial[/TD]
[TD]80%[/TD]
[/TR]
[TR]
[TD]Retail[/TD]
[TD]80%[/TD]
[/TR]
</tbody>[/TABLE]


Basically I need to populate Column N in table 1.

If Column G in table 1 = Column A in table 2, then Column N will have the data shown in Column B for the corresponding item.


Hope that makes sense and I can get some help.

Cheers

 

[jtakw]

Hi,

Book1
	G	N
1	Eff Code	Eff
2	Multistorey Unit	75%
3	Commercial	80%
4	Retail	80%
Sheet150

Cell Formulas
Range	Formula
N2	=IFERROR(VLOOKUP(G2,Sheet151!A$1:B$3,2,0),"")

Book1
	A	B
1	Multistorey Unit	75%
2	Commercial	80%
3	Retail	80%
Sheet151

N2 formula copied down, if no match is found, results Blank.
Change Sheet name in formula to match your Sheet 2.
Format Column N as "Percentage"