excel

[dvd_holc]

I want to set up a lookup function that will look up column 1 and column 2 to get a value in column X. Example:

Column 1 Column 2 Column X
row 1 a 1 10
row 2 a 2 20
row 3 b 1 15
row 4 b 2 35


so I want to search column 1 for "a" and column 2 "2" to get value 20

What do I function(s) do I write in excel?

 

[galaxym1]

There is a tricky way to do this.

insert extra column before Column X, suppose column W. in this extra column concatenate the values in column 1 and column 2. Use the formula like: A1&B1 to concatenate values in column 1 and column 2 Now, you will have:
column 1
column 2
column W (A1&B1)
column X

Also, you have to concatenate both columns on the other file,sheet. Now, you can perform lookup on column W, and get column X.

Good Luck brother

 

[dysert]

There is a tricky way to do this.

insert extra column before Column X, suppose column W. in this extra column concatenate the values in column 1 and column 2. Use the formula like: A1&B1 to concatenate values in column 1 and column 2 Now, you will have:
column 1
column 2
column W (A1&B1)
column X

Also, you have to concatenate both columns on the other file,sheet. Now, you can perform lookup on column W, and get column X.

Good Luck brother

That's a good idea. And to answer the original question, you'd use the VLOOKUP function.