Bottom up Lookup Formula

[marlonsosa]

Hi,

I have this data:

12345FDEYes 11-5 12345 FDE (Blank) Yes 15140 1 1.0000 3851
12345FDEYes 11-5 12345 FDE Outbound Yes 15141 1 1.0000 3852

That's 2 rows 11 columns (real spreadsheet has 15k+ rows). Rows are almost the same, but you see in the last column to the far right there's one digit that's different. If I do a regular vlookup it will return the first top to bottom (3851). I need a formula that works bottom up to return 3852. I am using this one:

=LOOKUP(2,1/multiline!A:A=master!A10666,multiline!K:K)

I have data in 2 separate sheets, master and multiline. I don't know what the "2" or the "1/" do in the formula, but anyways it's not working, returns #N/A. Any ideas?

 

[sheetspread]

Try:

=LOOKUP(2,1/(multiline!A:A=master!A10666),multiline!K:K)

 

[marlonsosa]

I'm serious, I've never been able to do a bottom up lookup, had this doubt for years!