| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
refer to other xls file
I have this formula. =IF(A4<"",VLOOKUP(B4,CURRENT!$A$2:$C$1647,3,FALSE )*(A4),"") it takes information from another sheet. the "CURRENT" sheet, but how do I make this take from the "CURRENT INVENTORY PRICING.xls"? -- DKY ------------------------------------------------------------------------ DKY's Profile: http://www.excelforum.com/member.php...o&userid=14515 View this thread: http://www.excelforum.com/showthread...hreadid=318873 |
|
#2
|
|||
|
|||
|
Hi
- open both files - select the range with your mouse from the other file/sheet -- Regards Frank Kabel Frankfurt, Germany "DKY" schrieb im Newsbeitrag ... I have this formula. =IF(A4<"",VLOOKUP(B4,CURRENT!$A$2:$C$1647,3,FALSE )*(A4),"") it takes information from another sheet. the "CURRENT" sheet, but how do I make this take from the "CURRENT INVENTORY PRICING.xls"? -- DKY --------------------------------------------------------------------- --- DKY's Profile: http://www.excelforum.com/member.php...o&userid=14515 View this thread: http://www.excelforum.com/showthread...hreadid=318873 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
| File asks to update when no links were created | Links and Linking in Excel | |||
| File is locked for Editing by user problem | Excel Discussion (Misc queries) | |||
| format question when open csv file | Excel Discussion (Misc queries) | |||
| Convert text file to MS_Excel | Excel Discussion (Misc queries) | |||
Linear Mode
