Vlookup to append a field from one tab to another [SOLVED]

[Jaimee001]

Hi All, I do love this site.....I'm so thankful for all of the help that is here. That being said, I have a question. I have a workbook with 2 tabs. I've mocked them in in this report:

[pre]http://speedy.sh/FuEQe/Director-Example.xlsx[/pre]


Tab one DATA has a lot of columns (I've scaled it back a bit) I need to append the director from the 2nd tab to tab1. I'm not sure what to make the match on.

Usually I deal with numbers, so text throws me off....

I've tried all sorts of VLookups and can't get any to work.

Thanks in advance....

 

[SirJB7]

Hi, Jaimee001!


In I2 try this:

=SI(ESBLANCO(BUSCARV(H2;'Director Info'!A:C;3;FALSO));"";BUSCARV(H2;'Director Info'!A:C;3;FALSO)) -----> in english: =IF(ISBLANK(VLOOKUP(H2,'Director Info'!A:C,3,FALSE)),"",VLOOKUP(H2,'Director Info'!A:C,3,FALSE))


If it weren't for the empty values like of Jay Keebo or if you don't mind appearing a zero, you can reduce the formula just to the last VLOOKUP.


Regards!

 

[Jaimee001]

Thank you Sir JB7,

However, instead of appending the actual name of the director, I'm getting "false" in that column:

Full Name Director

Jaimee L Beebo FALSE


How can I tweak the formula to get the actual name?

 

[SirJB7]

Hi, Jaimee001!

I'm getting a blank

Could you check it copying the formula from previous post and pasting it into I2 cell and then copying down?

Do that in your uploaded file, just to be sure we're talking about the same data.

Regards!

 

[Jaimee001]

Hi SirJB7,

Here is the updated link with the formula in column I:


http://speedy.sh/f9FFk/Director-Example.xlsx


Thank you!

 

[Debraj]

Hi Jamie001,


FYI, below is the complete formula of SirJB7..


=IF(ISBLANK(VLOOKUP(H2,'Director Info'!A:C,3,FALSE)),"",VLOOKUP(H2,'Director Info'!A:C,3,FALSE))


Regards,

Deb

 

[Jaimee001]

Thank you both!!!! it works perfectly!!!!!

 

[Debraj]

Hi Jaimee001..


Glad that you solved it.. [SOLVED]

 

[SirJB7]

Hi, Jaimee001!

Glad you solved it. Thanks for your feedback and for your kind words too. And welcome back whenever needed or wanted.

Regards!


@Debraj Roy

Hi!

Thanks for the support.

Regards!

PS: Just at 18...