vlookup???

[Jaimee001]

Hi there,

I'm have a large report and I need to append some data to it. I've attached a copy:

[pre]http://speedy.sh/cTNUJ/vlookup-for-industry.xlsx[/pre]


In the first tab, there are 6 accounts and US National accounts have an industry code and industry code descriptor.

The US District have their industry code info blank.

The 2nd sheet is the updates for the US District accounts. I just want to update those 4 accounts with the industry info.....I'm worried that a VLookup will delete the existing information

Thanks in advance!!!!!

Jaimee

 

[jason]

your code didnt work... may want to review the sticky on the main forum page.


a vlookup will not delete any content, it simply retrieves data from the specified table array.

 

[Jaimee001]

Hi Jason,

Here is the correct link to the sample report:

http://speedy.sh/Kh25w/vlookup-for-industry.xlsx


I did try a VLookup and on those accounts where there isn't a match and there is an industry code, it changed to #NA. Is there a way to 'skip' those accounts that already have an industry code?


Thanks in advance

Jaimee

 

[oldchippy]

Hi,


Try this in H2 copied down


=IFERROR(VLOOKUP(A2,updates!$A$2:$G$4,4,FALSE),D2)

 

[Jaimee001]

Thank you OldChippy!!! It took me a bit but I totally get it!!!


THANK YOU SO MUCH!!! I've spent WAY too much time trying to figure this out!!!

 

[oldchippy]

Jaimee001,


Glad it helped


You will notice that the returned values are now numbers and not text values as your original data. If this is a problem and you require them to be text values then I suggest you format say column J as TEXT, then copy column H and then paste special > values to H, they will then be text values