vlookup function

[bumgr]

I have data in following manner

sheet 1
col1 col2 col3
aa tt 25

sheet 2
col1 col2 col3
aa tt ------ HERE I want value 25 w/o changing sheet1 data through
vlookup function is possible ???
pl. help
Thanks

 

[rconverse]

Do you want to match to TT in column 2 or do you need to match to records that have AA in column 1 and TT in column 2?

 

[Misca]

I'd solve this using INDEX:

Excel Workbook
	A	B	C	D	E	F	G
1	aa	bb	21		Column 1	Column 2	Column 3
2	aa	ff	22		aa	tt	25
3	aa	tt	25		aa	bb	21
Sheet

The example uses the same sheet but it's just the same with two sheets. The only difference is you need to use the sheet names in the formulas (or named ranges).

 

[rconverse]

^MATCH(E2&F2,INDEX($A$1:$A$3&$B$1:$B$3,,)

That's pretty cool. Never thought of that.

 

[bumgr]

I want value of col3 by matching value of col1 i.e. AA and col2 i.e. TT

if data 1 as follows

A1 B1 C1
AA TT 115


DATA 2

A1 B1 C1
AA TT IT SHOULD BE 115

 

[rconverse]

I want value of col3 by matching value of col1 i.e. AA and col2 i.e. TT

if data 1 as follows

A1 B1 C1
AA TT 115


DATA 2

A1 B1 C1
AA TT IT SHOULD BE 115

Post number 3 provides the solution for which you are looking.

 

[T. Valko]

I want value of col3 by matching value of col1 i.e. AA and col2 i.e. TT

if data 1 as follows

A1 B1 C1
AA TT 115


DATA 2

A1 B1 C1
AA TT IT SHOULD BE 115

Is the value to be returned always a number?

Is the combination of lookup values always unique? In other words, will the combination of AA & TT appear only once in the data set?

What version of Excel are you using?