Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am trying to match to arrays in two different Excel tabs I will make a
sample of each tab. Tabl A B C 12 150 Class 10 150 No Class Tab2 A B C D 12 150 NoClass 350 10 150 NoClass 400 What I am trying to do, is to Match Columns (A,B,C) from Tab1 to Tab2, and to display the value of Column D. I can get this to work by matching Column A from Tab1 to Tab2 and displaying Column D, using the Vlookup() function. I just can't figure out how to much mutiple columns in a row between tabs. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Where is the bug in my array? | Excel Discussion (Misc queries) | |||
Help with array formula | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions | |||
VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) |