Look up of 2 columns

Having real issues trying to get Column A to match with Column G... (see attached sheet)

All I want it to do is look up the 4 digit code from column A and compare it to column G's 4 digit code...
And bring back the corresponding address... columns G and H.


Ie if I was searching for code 0024 it would bring back the information from column G with 0024 in it...

Then put that information in some other cells... say L and M.

I tried using vlookup and match commands... and it works for the first cell... but when I copy the forumla down it bugs out and does not work.

Thanks very much for your help, I will leave rep etc for anyone that help.



Regards,

James

You're numbers are stored as special rather than text in the far left column. If you try to vlookup that, it will not work because they are different types of data. Try converting your left column to numbers, or text, or special. Just as long as they are all the same.

If that is not an option, have a dummy series that has the information you want (the numbers) and store that as text. Then link the lookup to those cells.

Try this formula in row 2, say cell L2:
=IF(ISERROR(VLOOKUP(G2+0,$A$2:$B$38,2,FALSE)),"",VLOOKUP(G2+0,$A$2:$B$38,2,FALSE))

Copy down
===========
You may have had problems because some of you data is numeric and some text. The +0 converts the text to a number
============
BTW: The formula could be shortened if you used IFERROR