| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need to work across two sheets in excel 2003
I need to be able to put in column b4 on sheet 1 the answer to this, on sheet
2 find "AC" in column C and put the corresponding name in column A, in b4 on sheet 1. (excel 2003) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
need to work across two sheets in excel 2003
Hi Vandy
In B4 enter =INDEX(Sheet2!$A:$A,MATCH(Sheet2!$C:$C,"AC",0)) better still would be if your Value AC was entered in A4, then substitute that in the formula =INDEX(Sheet2!$A:$A,MATCH(Sheet2!$C:$C,A4,0)) -- Regards Roger Govier "Vandy" wrote in message ... I need to be able to put in column b4 on sheet 1 the answer to this, on sheet 2 find "AC" in column C and put the corresponding name in column A, in b4 on sheet 1. (excel 2003) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
need to work across two sheets in excel 2003
Sorry Vandy, typed that incorrectly
It should read =INDEX(Sheet2!$A:$A,MATCH("AC",Sheet2!$C:$C,0)) and =INDEX(Sheet2!$A:$A,MATCH(A4,Sheet2!$C:$C,0)) -- Regards Roger Govier "Roger Govier" <roger@technology4unospamdotcodotuk wrote in message ... Hi Vandy In B4 enter =INDEX(Sheet2!$A:$A,MATCH(Sheet2!$C:$C,"AC",0)) better still would be if your Value AC was entered in A4, then substitute that in the formula =INDEX(Sheet2!$A:$A,MATCH(Sheet2!$C:$C,A4,0)) -- Regards Roger Govier "Vandy" wrote in message ... I need to be able to put in column b4 on sheet 1 the answer to this, on sheet 2 find "AC" in column C and put the corresponding name in column A, in b4 on sheet 1. (excel 2003) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
need to work across two sheets in excel 2003
Thank You....it works.. Have a great day!
"Roger Govier" wrote: Sorry Vandy, typed that incorrectly It should read =INDEX(Sheet2!$A:$A,MATCH("AC",Sheet2!$C:$C,0)) and =INDEX(Sheet2!$A:$A,MATCH(A4,Sheet2!$C:$C,0)) -- Regards Roger Govier "Roger Govier" <roger@technology4unospamdotcodotuk wrote in message ... Hi Vandy In B4 enter =INDEX(Sheet2!$A:$A,MATCH(Sheet2!$C:$C,"AC",0)) better still would be if your Value AC was entered in A4, then substitute that in the formula =INDEX(Sheet2!$A:$A,MATCH(Sheet2!$C:$C,A4,0)) -- Regards Roger Govier "Vandy" wrote in message ... I need to be able to put in column b4 on sheet 1 the answer to this, on sheet 2 find "AC" in column C and put the corresponding name in column A, in b4 on sheet 1. (excel 2003) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I repeat XML map in sheets of the same excel work book | Excel Discussion (Misc queries) | |||
| deleted work sheets - Excel | Excel Worksheet Functions | |||
| Counting dates in multiple work sheets and work books | Excel Discussion (Misc queries) | |||
| How can I merge and purge two excel work sheets? | New Users to Excel | |||
| Excel Work Sheets | Excel Discussion (Misc queries) | |||
Linear Mode
