Home |
Search |
Today's Posts |
#1
|
|||
|
|||
create reference formula that looks through all sheets for matchin
I thought I've done this in the distant past, but not sure how it was
done...Trying to create reference formula that looks through ALL worksheets for matching sheet name and also for matching data that is referenced...ex. Sheet1 and Sheet2 have different data in non-identical ranges with identical column names starting at B3(I'm using range B3:P50). I've used the Standard Vlookup Formula and the combo of Vlookup and Indirect, but they don't sork when trying to reference another Workbook! As I stated, I know it's possible, I no longer have any of the files where it worked. =Vlookup($C$5,Indirect("'"&A5&"'!B2:P50"),4,0) Sheet1 Sheet2 Item Yr 1 Yr 2 Item Yr 1 Yr 2 a 13 14 a 12 13 b 13 14 b 14 15 c 14 15 c 15 16 Sheet3 (Output page in same Wkbk) This works! But Not if it's in another Wkbk! Product A 15 c Product B 14 ANY HELP in RESOLVING THIS IS GREATLY APPRECIATED!!! BMW |
#2
|
|||
|
|||
create reference formula that looks through all sheets for matchin
Sheet1 and Sheet 2 should be "ProductA and ProductB" respectively...Sorry for
the confusion! BMW "BMW" wrote: I thought I've done this in the distant past, but not sure how it was done...Trying to create reference formula that looks through ALL worksheets for matching sheet name and also for matching data that is referenced...ex. Sheet1 and Sheet2 have different data in non-identical ranges with identical column names starting at B3(I'm using range B3:P50). I've used the Standard Vlookup Formula and the combo of Vlookup and Indirect, but they don't sork when trying to reference another Workbook! As I stated, I know it's possible, I no longer have any of the files where it worked. =Vlookup($C$5,Indirect("'"&A5&"'!B2:P50"),4,0) Sheet1 Sheet2 Item Yr 1 Yr 2 Item Yr 1 Yr 2 a 13 14 a 12 13 b 13 14 b 14 15 c 14 15 c 15 16 Sheet3 (Output page in same Wkbk) This works! But Not if it's in another Wkbk! Product A 15 c Product B 14 ANY HELP in RESOLVING THIS IS GREATLY APPRECIATED!!! BMW |
#3
|
|||
|
|||
create reference formula that looks through all sheets for mat
Is Everyone Baffled by this request??? I need the syntax for formulas: One
that will look in ALL wksheets (Global) in the same wkbook, and also one that will look in another wkbk in ALL wksheets (Global)...URGENT REQUEST! PLEASE SEE MY EXAMPLE BELOW!!! "BMW" "BMW" wrote: Sheet1 and Sheet 2 should be "ProductA and ProductB" respectively...Sorry for the confusion! BMW "BMW" wrote: I thought I've done this in the distant past, but not sure how it was done...Trying to create reference formula that looks through ALL worksheets for matching sheet name and also for matching data that is referenced...ex. Sheet1 and Sheet2 have different data in non-identical ranges with identical column names starting at B3(I'm using range B3:P50). I've used the Standard Vlookup Formula and the combo of Vlookup and Indirect, but they don't sork when trying to reference another Workbook! As I stated, I know it's possible, I no longer have any of the files where it worked. =Vlookup($C$5,Indirect("'"&A5&"'!B2:P50"),4,0) Sheet1 Sheet2 Item Yr 1 Yr 2 Item Yr 1 Yr 2 a 13 14 a 12 13 b 13 14 b 14 15 c 14 15 c 15 16 Sheet3 (Output page in same Wkbk) This works! But Not if it's in another Wkbk! Product A 15 c Product B 14 ANY HELP in RESOLVING THIS IS GREATLY APPRECIATED!!! BMW |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reference to sheets without using sheet names | Excel Worksheet Functions | |||
How can formulas be used to create another formula? | Excel Discussion (Misc queries) | |||
Using a formula to create named range reference | Excel Worksheet Functions | |||
How to create specific formula | Excel Worksheet Functions | |||
How to change a formula reference? | Excel Discussion (Misc queries) |