VLOOKUP keeps bringing up blank cell

[tamhav]

Hi Guys,

i have attached the spread sheet, but basically i have a sheet with ALLOT of data on it, first row is the code and second row is the description for the code.
On sheet 1 i need to enter the code submitted in Cell A and then i need it to search that code and give the description on Cell B.

im currently using IFERROR(IF(B3="";"";VLOOKUP(B3;ICD;2;FALSE));"") ----> ICD is the name given to all the data. Ive used this before and it worked so why not anymore?

BUT this just brings up a blank cell. Ive also noticed now that if i want to referance the cell to another sheet (=B21) is just says =B1 in the cell and does not referance it anymore.

Any ideas?

Thanks in advance

[NeedForExcel]

Here!

This should work in Cell B2 - =IFERROR(IF(B2="","",VLOOKUP(B2,ICD,2,0)),"")

There are spaces in A Column of ICD..

Find and Replace those then the formula will work

[LokeshKumar]

Hi,

You have done all things well just a very silly error..
ICD defines name= There are some blank space in your data use this.......
Press Ctr+Shift+Enter as this is CSE/Array formula.....

Please Login or Register  to view this content.

If your question is resolved, mark it SOLVED using the thread tools. Click on the star if you think some-1 helped you.

[tamhav]

MY SPACE BAR HATES ME CLEARLY!!

Thanks guys, only 2800 cells to check - but its working. But can you please tell me how you figured that one out? would be interesting for next time

[LokeshKumar]

Please Click STAR to Add Reputation if my/someone's answer helped!

[NeedForExcel]

Thanks guys, only 2800 cells to check - but its working.

Hope you are not removing one space at a time.. You can do it all at once using Find & Replace.. Put a space in the Find sections and leave the replace section as is..

[tamhav]

I did use find & replace, but to look busy at the office i did tell them its going to take a while....