Change lookup to match/lookup function

Hi,

I have a vlookup

=VLOOKUP('T-2'!AE2,'Raw Data'!AE:AI,5,0)

I want to change this to a match/lookup

So i would like it to match AE2 from Tab "T-2" into Col AE in tab "Raw Data" and once found, return the value from the adjacent column AI in raw data

Thanks
Seamus
Seamus2626Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rory ArchibaldCommented:
Not sure I understand - that's what your formula does.
0
mrklaxonCommented:
May want to script it but if just want an Excel formula:

=INDEX('SourceWorksheet'!$C$1:$C$4,MATCH(D3,'SourceWorksheet'!$B$1:$B$4,0))

This assumes a table in another sheet has the data.  What is says is return the info in row from column C looking for data matching D3 of the active worksheet to column B in the table worksheet.
0
Rory ArchibaldCommented:
If you want it as an INDEX/MATCH then it's:

=INDEX('Raw Data'!AI:AI,MATCH('T-2'!AE2,'Raw Data'!AE:AE,0))
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

Seamus2626Author Commented:
Hey Rory i attached a spreadsheet where you can see in tab Raw Data i am looking at AE2 in T-2, seeing can i find it in Raw Data and returning Col AI.

What i want to do though is start at AE2 in T-2, and match into Raw Data, then return the Col AI

The point of the exercise is to see if a reference exists in T-2 and then exists in Raw Data, has  Col AI (Area) changed

Thanks
Seamus
test.xls
0
Rory ArchibaldCommented:
Still no idea what it is you want as your spreadsheet already does what I think you are describing.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Seamus2626Author Commented:
This is true, the lookup was already achieving what i wanted. Back to the drawing board....
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.