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)