| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 Cols To 2 Cols VLookup Comparison
Can anyone help? Need to know if there is a way to compare 2 cols. to 2
cols. VLookup. Info I have is for 1 col to 1 col. (single col. comparison) Is there a way to compare multiple cols.? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
2 Cols To 2 Cols VLookup Comparison
You can concatenate both columns to form a one to one comparison.
-- http://HelpExcel.com "CuriousMe" wrote: Can anyone help? Need to know if there is a way to compare 2 cols. to 2 cols. VLookup. Info I have is for 1 col to 1 col. (single col. comparison) Is there a way to compare multiple cols.? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
2 Cols To 2 Cols VLookup Comparison
Sure is:
Say you have names in col A, ages in col B, and address in col C. In D1 you have the name of a person, and in E1 you have their age. You want to know what their address is (ie col C value) from the list. You can use: =INDEX($C$1:$C$5,MATCH(1,($A$1:$A$5=D1)*($B$1:$B$5 =E1),0)) (obviously adjust ranges to suit - I have only used 5 cells here). This is an array formula so must be array-entered (Ctrl+Shift+Enter). Hope this helps! Richard CuriousMe wrote: Can anyone help? Need to know if there is a way to compare 2 cols. to 2 cols. VLookup. Info I have is for 1 col to 1 col. (single col. comparison) Is there a way to compare multiple cols.? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
2 Cols To 2 Cols VLookup Comparison
Thank you for your response...Merry Christmas!!
"galimi" wrote: You can concatenate both columns to form a one to one comparison. -- http://HelpExcel.com "CuriousMe" wrote: Can anyone help? Need to know if there is a way to compare 2 cols. to 2 cols. VLookup. Info I have is for 1 col to 1 col. (single col. comparison) Is there a way to compare multiple cols.? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
2 Cols To 2 Cols VLookup Comparison
Thanks so much...Merry Christmas!
"RichardSchollar" wrote: Sure is: Say you have names in col A, ages in col B, and address in col C. In D1 you have the name of a person, and in E1 you have their age. You want to know what their address is (ie col C value) from the list. You can use: =INDEX($C$1:$C$5,MATCH(1,($A$1:$A$5=D1)*($B$1:$B$5 =E1),0)) (obviously adjust ranges to suit - I have only used 5 cells here). This is an array formula so must be array-entered (Ctrl+Shift+Enter). Hope this helps! Richard CuriousMe wrote: Can anyone help? Need to know if there is a way to compare 2 cols. to 2 cols. VLookup. Info I have is for 1 col to 1 col. (single col. comparison) Is there a way to compare multiple cols.? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
| VLOOKUP using another table for comparison values | Excel Worksheet Functions | |||
| VLOOKUP Problem | Excel Discussion (Misc queries) | |||
| Date Comparison with VLookup | Excel Worksheet Functions | |||
| vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Linear Mode
