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

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
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,223,098
Messages
6,170,103
Members
452,302
Latest member
TaMere

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