vlookup function

bumgr

New Member
Joined
Apr 13, 2011
Messages
3
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
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
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?
 
Upvote 0
I'd solve this using INDEX:
Excel Workbook
ABCDEFG
1aabb21Column 1Column 2Column 3
2aaff22aatt25
3aatt25aabb21
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).
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0
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?
 
Upvote 0

Forum statistics

Threads
1,224,609
Messages
6,179,876
Members
452,949
Latest member
Dupuhini

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top