Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
will Vlookup work for this...
Hello,
I am trying to utilize Vlookup to search for an item using two values in order to find the necessary third value at a specified column. One of the values for the look up is a number while the other one is a letter (or text/word) I want to be able to look up these two values in order to find the third as below: Spreadsheet 1 Column A: Column B: spreadsheet #2---- column A B C Green 34 Green 34 V1 Green 35 V2 Green 33 V3 so buy just using the first two values of spreadsheet 1 i can get the value needed in spreadsheet 2 which is in column C. I hope this makes sence. Thank you in advance, TG |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
will Vlookup work for this...
Try something like this array formula** :
=INDEX(Sheet2!C1:C10,MATCH(1,(Sheet2!A1:A10=A1)*(S heet2!B1:B10=B1),0)) ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER) -- Biff Microsoft Excel MVP "TG" wrote in message ... Hello, I am trying to utilize Vlookup to search for an item using two values in order to find the necessary third value at a specified column. One of the values for the look up is a number while the other one is a letter (or text/word) I want to be able to look up these two values in order to find the third as below: Spreadsheet 1 Column A: Column B: spreadsheet #2---- column A B C Green 34 Green 34 V1 Green 35 V2 Green 33 V3 so buy just using the first two values of spreadsheet 1 i can get the value needed in spreadsheet 2 which is in column C. I hope this makes sence. Thank you in advance, TG |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup doesn't work | Excel Worksheet Functions | |||
will vlookup work for me? | Excel Worksheet Functions | |||
VLookup won't work | Excel Discussion (Misc queries) | |||
Countif + vLookup: Can they work together? | Excel Discussion (Misc queries) | |||
VLOOKUP won't work | Excel Worksheet Functions |