T
TG
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
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