Compare from 2 columns and retrive from third

[abhabhishek]

I have an excel file with 2 workbooks, one consists of
ID and Sales
and another consists of
Client Name and Price
I want, if I write Name for ID in 1st sheet then respective Sales block should take the Price value from 2nd workbook of respective Client
Note: the values in ID and Client Name are same.
Please help.

 

[Joe4]

Welcome to the Board!

I assume that you mean "an excel file with 2 worksheets" and not "an excel file with 2 workbooks", as the latter does not make any sense (files and workbooks are the same thing).

It sounds like what you are looking for might be the VLOOKUP function. See: https://www.techonthenet.com/excel/formulas/vlookup.php

If that does not appear to solve your issue, perhaps try posting some example data and your expected output.