| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| compare two columns data and bring them to another work sheet | Excel Discussion (Misc queries) | |||
| Cell compare has issue with MAJOR text | Excel Discussion (Misc queries) | |||
| SUMPRODUCT that bring Text | Excel Worksheet Functions | |||
| using formula to compare two text lists that are not alike and ma. | Excel Worksheet Functions | |||
| Find a non-blank cell and bring back text a in same row | Excel Worksheet Functions | |||
Linear Mode
