Thread: Lookup and Filtering

In column A I have a list of names, each unique. In column B I have a function that calculates a number specific for the name in column A.

However, in one row, I would like to modify the formula in column B to lookup a certain name in column A and return .75 multiplied by the corresponding value in column B.

This is what I was thinking:

=Lookup("Column A Value of Interest", A:A, B:B) * .75

This works well, but when sorting the columns in a way that changes the row's positions, the formula does not hold true. Any suggestions on a formula that would accomplish what I've described above and also can withstand sorting?

Thanks!

Lookup needs the column A items to be sorted in ascending order..

If you want an exact match, and the list may not be sorted, then try VLOOKUP

eg.

=VLookup("Column A Value of Interest", A:B,2,FALSE) * .75