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

G

Guest

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
Compare data in one sheet to another 1
Return value matching vertical and horizontal input 5
Lookup value with multiple criteria using data from 2 different sheets 0
Find match between cells and copy data 7
Compare 1 cell to column of cells returning adjacent cells info? 1
Connecting data between 2 spreadsheets 2
How to retrieve the value from formula? 4

Top