Vlookup or match or if?

[robholmes]

I have a table formatted as such

lookup.JPG

How can i match A with G and move then place the corresponding H into C? I tried VLOOKUP but it skips the entry on row five because it is a duplicate....


Thoughts?

[Tony Valko]

Not real sure what you're wanting to do.

My best guess...

Data Range

	A	B	C	D	E	F	G	H
1	123	dog	house	------	------	------	123	house
2	1234	cat	house				1234	house
3	12346	lion	zoo				12346	zoo
4	12345	mouse	house				12345	house
5	12345	mouse	house

This formula entered in C1 and copied down:

=VLOOKUP(A1,G$1:H$4,2,0)