Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Formula to match,lookup and then retun alternate value

  Asked By: Harry    Date: Sep 12    Category: MS Office    Views: 761
  

In Excel I have a SQL query.
I want to compare the cell value in d3 "linda" on sheet1, which has
the source connection, to an array located on a different sheet.
Once found I want to return the value from column I of that row on
the second sheet .
The array is located in column A the data I want is in column I.
When I try to build my formula another column header is created on
the 1st,( that has the sql connection)
Second problem the reference the second sheet generates errors
Third I have no idea how to return the actual value that I need.
This is as far as I can get

=INDIRECT(ADDRESS(MATCH(D3,'Feed '!A2:A6934),1)

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on Formula to match,lookup and then retun alternate value Or get search suggestion and latest updates.




Tagged: