| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Lookup between two worksheets
I have the foll prob, i have two worhsheets with values in column A matching
values in column C A1 = 6 and C1 = Cat A B C 1 6 Dog Cat 2 7 Pig Rat 3 17 x y Next sheet A30 = 6 and C30 = ? A B C 30 6 fly ? 31 3 tin can 32 17 d n Can i write a formula in second worksheet to go look in first worksheet and see the relationship between A1/C1 and get the value of C1 and make C32 = C1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup between two worksheets | New Users to Excel | |||
| Lookup between two worksheets | New Users to Excel | |||
| Lookup across multiple worksheets | Excel Worksheet Functions | |||
| Lookup across multiple worksheets | Excel Worksheet Functions | |||
| need check two worksheets to lookup a value | Excel Discussion (Misc queries) | |||
Threaded Mode
