ExcelBanter - formula 2 compare text in one cell to another and bring value

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - formula 2 compare text in one cell to another and bring value (https://www.excelbanter.com/excel-worksheet-functions/136196-formula-2-compare-text-one-cell-another-bring-value.html)

Shariq

formula 2 compare text in one cell to another and bring value

I have 2 compare model in one worksheet 2 model in another and if it matches
then bring the corresponding value, would any formula work?If yes then please
share with example...

Example:
Model 1 in column A of work sheet x
Model 1 in coulmn A OF work sheet y
Result: Value z from sheey y in column B of sheet x

Toppers

formula 2 compare text in one cell to another and bring value

See the VLOOKUP function:

in (for example) B2 of Sheet1

=VLOOKUP(A2,Sheet2!A:Z,2,0)

will return entry in column B (signified by the 2) in models match.

HTH

"Shariq" wrote:

I have 2 compare model in one worksheet 2 model in another and if it matches
then bring the corresponding value, would any formula work?If yes then please
share with example...

Example:
Model 1 in column A of work sheet x
Model 1 in coulmn A OF work sheet y
Result: Value z from sheey y in column B of sheet x

All times are GMT +1. The time now is 02:44 AM.