lookup_value

Can the lookup_value within a MATCH function use the Concatenated value of two cells to identify the COLUMN number of a spreadsheet? MATCH(lookup_value, lookup_array, [match_type]) Something like this is what I'm attempting : MATCH(CONCAT(A1,"-"B1),Sheet2!$3:$3,0) Airic

I have recently had a series of problems with Vlookup where the lookup_value has a character length >7 digits. I found a way around the problem with Index and Match, but now wonder is it a known glitch or something wrong with my computer, Excel version v2016?

Hi Everyone, This is probably a really simple thing but when inserting the VLOOKUP function, what is an easy way to know and remember what to insert in each of the parts of function like in lookup_value, table_array and col_index_num? It confuses me as to what to put in each.

I am trying to find a way to pull info from a string and use that as a lookup_value for VLOOKUP. I cam up with the equation =VLOOKUP(IFERROR(LEFT($C4,FIND("x",$C4,1)-2),"NA"),H4:I20,2,FALSE) however it keeps returning an error. I know the VLOOKUP works and i know the IFERROR works, am i missing...

I have a large data set with a 'description' column that is not always uniform, for example it could read "bla bla bla depreciation" or "depreciation bla bla bla" and both should be tagged as 'Depreciation' in a separate tagging column. Is there a way/formula which I could create a mapping...

Hi, I think this question would have a simple solution but I can not seem to find the answer so I will try to post it instead. I have a table that has 77 names on the first column and their scores on the second column. I created another table using the LARGE function to find the top 10 scores...