• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 243
  • Last Modified:

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
0
Seamus2626
Asked:
Seamus2626
  • 3
  • 2
2 Solutions
 
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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
 
Seamus2626Author Commented:
This is true, the lookup was already achieving what i wanted. Back to the drawing board....
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now