Excel Formula

[raajnabriz]

Hi,
I have 2 workbook as follows

The other is

Need a formula to check the content of C from one workbook in the source book and copy the content from column K & L in D & E.

Thanks,

 

[Joe4]

You should be able to use VLOOKUP to lookup and return those values.
See this here for a demonstration on how to use VLOOKUP across workbooks: Excel VLOOKUP function tutorial with formula examples

 

[raajnabriz]

I will check it out and let u know.
Thanks

 

[raajnabriz]

You should be able to use VLOOKUP to lookup and return those values.
See this here for a demonstration on how to use VLOOKUP across workbooks: Excel VLOOKUP function tutorial with formula examples

Hi,
I tried my best to use the Vlookup formula, but it is giving #Ref!
I tried using the following formulas

=VLOOKUP(C2,[Test2.xlsx]sbsv2!$B$2:$B$21,3,FALSE)

=VLOOKUP(C2,[Test2.xlsx]sbsv2!$B$2:$B$21,[Test2.xlsx]sbsv2!$C$2:$C$21,FALSE)

Kindly let me know the error in my formula.

Thanks,
Raaj.

 

[raajnabriz]

You should be able to use VLOOKUP to lookup and return those values.
See this here for a demonstration on how to use VLOOKUP across workbooks: Excel VLOOKUP function tutorial with formula examples

Hi,
I hadn't selected the entire range in my above formulas, but now it is working
Thank you for your kind support. Appreciate it.

Regards,
Raaj.

 

[Joe4]

You are welcome.
Glad I was able to help!