Search: | |||||

| ||||

Home » Forum » MS Office | RSS Feeds |

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)

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.

Related Topics:

- Matching date values w/ dropdown values
- Looping thru values to match w/ other values
- VBA code to add values in two cells which have formulas
- Copy Value produced by formula in cell C3 to cell D3
- clearing cells value without deleting the formula I've made in cell from excel formula , HOW?
- formula help but not vba please
- How to add several conditions for formula "SUMIF"
- combining formula
- Formula using range name in VBA code
- Three Leveled Formula
- VBA Formula prob
- Getting a formula to copy from inside VBA
- Populate Formula(Function) in rows
- searching within formulas
- R1C1 Formula
- Paste Formula help
- 2003 - Moving to a formula address
- formula
- Any idea how to write formula?
- Formula with conditional text
- Please Help me in this Formula
- Manually creating a row outline with no formula anywhere
- Blank Formula bar
- Disabling Formulas, Not calculation
- Quotations in Formulas and strings