asked on 10/5/2011

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

Microsoft Excel

Last Comment

Seamus2626

10/5/2011

Rory Archibald

10/5/2011

Not sure I understand - that's what your formula does.

SOLUTION

mrklaxon

10/5/2011

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

Rory Archibald

10/5/2011

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))

Seamus2626

10/5/2011

ASKER

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

ASKER CERTIFIED SOLUTION

Rory Archibald

10/5/2011

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

Seamus2626

10/5/2011

ASKER

This is true, the lookup was already achieving what i wanted. Back to the drawing board....